Combine Data in two Sheets Using VLookup "#N/A" Error

[scomar411]

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

 

[fredlo2008]

Can you provide a sample workbook of what you want to achieve? Remove sensitive information.

Thanks

 

[Drrellik]

I suspect that your values are not the same. look at this link and see if you can find your error. If not please post some of your data. Why Does VLOOKUP Return An #N/A Error? | RAD Excel Don

 

[Aladin Akyurek]

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

Does J2 occur many times or just once on Add Data?

 

[scomar411]

I'm not sure how to load a workbook. I've read the FAQ but it is not clear how to use the HTML function to load a sheet. Any advice...sorry.

 

[fredlo2008]

you can use dropbox, google docs or other similar

 

[Aladin Akyurek]

Can you answer the question posed in post #4?

 

[CafeJr]

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:

(...)

Many thanks,
Scomar

Could be the order of data, these data must be classified by A to Z or 0 to 9... Another item is, if the column data (where are you looking the value) has a repeated data value, it could generate this kind of error...