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
Hi, It's pleasure to help you today:)
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
I manually added 'Titles Unknown;
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
Please review it. or download the file
User
30/10/2017 - 11:35
Great thanks!
User
30/10/2017 - 11:35
Works!
Excelchat Expert
30/10/2017 - 11:35
Attached
[Uploaded an Excel file]
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.