| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| Lookup on multiple values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| lookup multiple values | Excel Worksheet Functions | |||
| how do I lookup multiple values | Excel Discussion (Misc queries) | |||
![willemeulen[_35_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
