An easy way to get around this problem is to create a copy of the third
column (linked by formula) and place it just before the first column.
You can then use VLOOKUP.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544848