1. Names each sheet

2. Changed the entire number format to "general" for both sheets

2. Used the formula function in excel to create the vlookup. the formula looks like > =VLOOKUP(J2,'Add Data'!A1:S7422,14,FALSE)

After I do this get the "#N/A" error.

What should I do? Also, if there is a simple way to key on the one common data in both sheets and then pull multiple columns, I'd love to hear how.

Many thanks,

Scomar