In question, I have two spreadsheets in the same work book. The first is a partial list of TSX stock ticker symbols (text) in sorted column (A). The second is a complete and sorted list of TSX stock ticker symbols AND their associated long names (again, text) in two columns (A & B).

In the first spreadsheet and in an adjacent column, I want to display the long names associated with each ticker symbol.

In excel 2000, I used the formula [=VLOOKUP(A2,'TSX Listing'!$A$2:$D$1603,2,FALSE)] where TSX Listing is the complete source. However, in excel 2002, this formula displays the long name for the very last cell (A1598) in each and every cell in the first spreadsheet's 100 row column!

I've confirmed the cells are all in number format and when I use FALSE, I get a #N/A error. Is it me or has excel 2002 been modified?