I have two spreadsheets that I need to merge and am using a VLOOKUP formula.
Sheet 1 has ID numbers in column A; Sheet 2 has ID numbers in column A, last
names in column B, and first names in column C. I need Sheet 2 to merge into
Sheet 1, putting the correct name with the corresponding ID number.

I have a VLOOKUP formula in cell B1 Sheet1. What's my next step? The
formula is =VLOOKUP(A1,Sheet2!$A$1:$D$1000,2,FALSE)
--
Briggs