Attached is an example of a vlookup table with your data. But with that
large of a table I like the formula better.

I only populated 5000 lines of the table cause of the size limitation.

You could use the formula to arrive at column K and then use a much
smaller lookup table to populate H.


+-------------------------------------------------------------------+
|Filename: Vlookup.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5258 |
+-------------------------------------------------------------------+

--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=574277