I'm trying to use Excel V10 to combine data in two sheets and having a devil of a time. I'm trying to do this column by column but my ultimate goal is to pull several columns into my sheet by keying a common identifer in both. I did the following:
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
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