Have you tried using an Autofilter?

"gibbylinks" wrote:

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 ?