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

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

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

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