Hi,
I have a spreadsheet with random employee #'s in column A on sheet 1. On
sheet 2 I have employee #'s in column A, and employee names in column B. On
sheet 1 I want to add employee names in column B. I used the following in
code in B1, B2, & B3 respectively -
=VLOOKUP(A1,Sheet2!A1:B187,2)
=VLOOKUP(A2,Sheet2!A1:B187,2)
=VLOOKUP(A3,Sheet2!A1:B187,2)

For some reason only line 1 displays the employee name. I get #N/A on lines
2 & 3 yet on sheet 2 the numbers and names are present. Can someone tell me
what I'm missing?