# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

VLookup for Column A on Sheet1 to ColumnA on sheet 2, get ID and return values to Column B Sheet1
Solved by Z. L. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/10/2017 - 11:24
Excelchat Expert 30/10/2017 - 11:24
Please share the file or place sample info in the preview
User 30/10/2017 - 11:25
Hi - thanks copying and pasting data
User 30/10/2017 - 11:25
done
Excelchat Expert 30/10/2017 - 11:26
Ok. I am working on the requirement. Thanks for the inputs
User 30/10/2017 - 11:26
User 30/10/2017 - 11:26
those do not have IDs
Excelchat Expert 30/10/2017 - 11:26
I will add them through the formula. No worries
Excelchat Expert 30/10/2017 - 11:28
Can i use NA or Titles Unkown? Either of one?
User 30/10/2017 - 11:28
NA is fine
Excelchat Expert 30/10/2017 - 11:29
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"NA")
Excelchat Expert 30/10/2017 - 11:29
Here is the formula for B2 in sheet 1
Excelchat Expert 30/10/2017 - 11:29
Please copy till the end of the row in sheet1
User 30/10/2017 - 11:30
So NA is if I filled it and 0 is if there isn't a value correct?
User 30/10/2017 - 11:31
Example Row 217
Excelchat Expert 30/10/2017 - 11:31
Ok. there are some blanks.
Excelchat Expert 30/10/2017 - 11:32
Ok. I will update the formula to consider blank as NA
User 30/10/2017 - 11:32
no actually
User 30/10/2017 - 11:32
blank is fine
Excelchat Expert 30/10/2017 - 11:32
It is returned as zero, i will change to blank then
User 30/10/2017 - 11:32
If there are blanks I will find them directly in the master list
Excelchat Expert 30/10/2017 - 11:34
It was updated
Excelchat Expert 30/10/2017 - 11:34
=IFERROR(IF(VLOOKUP(A2,Sheet2!A:B,2,FALSE)="","",VLOOKUP(A2,Sheet2!A:B,2,FALSE)),"NA")
Excelchat Expert 30/10/2017 - 11:34
Here is the new formula
Excelchat Expert 30/10/2017 - 11:35
User 30/10/2017 - 11:35
Great thanks!
User 30/10/2017 - 11:35
Works!
Excelchat Expert 30/10/2017 - 11:35
Attached

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.