I'm assuming that VLOOKUP doesn't like the text, or the fact that the data is unsorted.<br><br>Perhaps I should be using INDEX or MATCH but I'm not clear on how to correctly incorporate them ...

Normally, VLOOKUP retrieves this data from cells within the spreadsheet. But Excel can import its data from other files as well, including comma separated value (CSV) files.