View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willemeulen[_35_] willemeulen[_35_] is offline
external usenet poster
 
Posts: 1
Default 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