Well a good start would be HLOOKUP or VLOOKUP. I use the HLOOKUP to find pricing. Our pricing is based on the quantity purchased (and a few other things). So the first column has 999 and the price covers anything less than 1000. The next column has 2499 and covers 1000 to 2499. It turns out that only one quantity is necessary. Excel will return the correct data as long as the values are sorted.
:HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
: Example "=hlookup(1250,B1:F1,2,FALSE)
Search B1 to F1, return the value from second row down, and approximate match is fine.
HTH get you started,
Rocky...