vlookup did work when i set range_lookup to true. i dont understand
why, but it does. i had it set on false because i wanted the exact
number and i dont understand why false would make vlookup only evaluate
the first column.

thank you mr shorty. i would also like to thank those of you with more
creative answers.

ive got my spreadsheet working now almost exactly as i first conceived
it. which is nice.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=380560