View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M.O.R. M.O.R. is offline
external usenet poster
 
Posts: 1
Default Table Lookup using two data elements

Hello,

I would like to be able to look up a price depending on both color & count
of items.
My table looks like:

# red blue green black
1-5 .20 .30 .31 .32
6-20 .15 .26 .28 .28

Such that if I ordered 18 blue pens the value returned would be (.26)
It seems that I need a combination of both V & H Lookup.