Lookup multiple values

[willemeulen]

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

 

[Mike H]

Hi,

Try this

=INDEX(Sheet1!H4:H69,MATCH(B5&C5&D5,Sheet1!A4:A69&Sheet1!B4:B69&Sheet1!C4:C69,0))

Mike

 

[Mike H]

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

Hi,

Try this

=INDEX(Sheet1!H4:H69,MATCH(B5&C5&D5,Sheet1!A4:A69&Sheet1!B4:B69&Sheet1!C4:C69,0))

Mike

 

[willemeulen]

The function above does not return a value, where do i indicate if must
be column 8 or H?