We're getting close. Thanks for your help. Here's where I'm at now. When I enter the value 6201 in A2 (which is the value I've been using for testing), everything works fine. When I change the value to something else (e.g. 6233), the data is populated, but it also returns #N/A errors where data wasn't found. This only happens on A2 values other than the original 6201 I have used for testing when I created the worksheet.

Here is a copy of the formula when A2 = 6203:

=IF(ISNA(MATCH(A2,'[FIT Phone Stats 2006 Sept.xls]2'!$B$5:$B$900,A2)),"",VLOOKUP(A2,'[FIT Phone Stats 2006 Sept.xls]2'!$B$5:$AE$900,2,FALSE))

Here is a copy of the formula from the same cell when A2 = 6233:

=IF(ISNA(MATCH(A2,'[FIT Phone Stats 2006 Sept.xls]2'!$B$5:$B$900,A2)),"",VLOOKUP(A2,'[FIT Phone Stats 2006 Sept.xls]2'!$B$5:$AE$900,2,FALSE))

The file path mentioned in my original posting is not shown here because I had both workbooks opened when I copied the formulas.

I cannot use Colo's html maker here. However, I did create jpegs of them if that would help.

Thanks again!