An easy way to get around this probelm 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.