lsu-i-like Wrote:
i tried vlookup but it only searches the first column of the table. ill
keep looking. True it only searches the first column, but with the range_lookup
argument set to the default TRUE (and with the data table sorted like
your sample table), it will still work. From Excel Help Range_lookup is a logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match. If TRUE or
omitted, an approximate match is returned. In other words, if an exact
match is not found, the next largest value that is less than
lookup_value is returned. If FALSE, VLOOKUP will find an exact match.
If one is not found, the error value #N/A is returned. In other words, if 8 is the lookup value, it looks in the left column
and doesn't find 8. So it decides to use the value in the 6 row
because 8 is between 6 and 11. Unless your real data table is set up
differently than your sample table, VLOOKUP would seem to work for you.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=380560