View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gibbylinks gibbylinks is offline
external usenet poster
 
Posts: 23
Default Best Solution for 3 search criteria

I have a table with columns 1 & 2 for size range (i.e 0 - 200mm, 201 - 400mm,
column 3 showing a number (0,1 or 2), columns 4 & 5 holding quantity ranges
and a cost in column 6.

I need to find the correct range based on size, then narrow the range based
on the number in column 3 and finally select the correct row for the price
based on quantity.

Can I do this ?