|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 8th, 2009, 09:41 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup multiple values
A need to retrieve a price depending on three values Material, class and size Material = B5 Class = C5 Size = D5 Vlookup column table Sheet1 A4:H69 Respectable values in columns A, B, C en returning value in Column H Vlookup or something else maybe? Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104421 
|
|
#2
June 8th, 2009, 11:10 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple values
Hi,
Try this =INDEX(Sheet1!H4:H69,MATCH(B5&C5&D5,Sheet1!A4:A69& Sheet1!B4:B69&Sheet1!C4:C69,0)) Mike "willemeulen" wrote: A need to retrieve a price depending on three values Material, class and size Material = B5 Class = C5 Size = D5 Vlookup column table Sheet1 A4:H69 Respectable values in columns A, B, C en returning value in Column H Vlookup or something else maybe? Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104421
|
|
#3
June 8th, 2009, 11:12 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple values
Hi,
I forgot to mention it's an array formula This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the formula {}. You can't type these yourself. If you edit the formula 'you must enter it again with CTRL+Shift+Enter. Mike "Mike H" wrote: Hi, Try this =INDEX(Sheet1!H4:H69,MATCH(B5&C5&D5,Sheet1!A4:A69& Sheet1!B4:B69&Sheet1!C4:C69,0)) Mike "willemeulen" wrote: A need to retrieve a price depending on three values Material, class and size Material = B5 Class = C5 Size = D5 Vlookup column table Sheet1 A4:H69 Respectable values in columns A, B, C en returning value in Column H Vlookup or something else maybe? Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104421
|
|
#4
June 10th, 2009, 02:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple values
The function above does not return a value, where do i indicate if must be column 8 or H?  -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104421
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
