View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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