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 ?
|