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