Hi All,
I have 2 sheets in my workbook.
1st sheet has 2 columns 1st column with numbers and second column with description.
in my second sheet, i have first column with numners. Now i need to put formula in second column which will search for that value in 1st column of 1st sheet andif it exists its description from first sheet will be placed in the 2nd column of 2nd sheet...
Pls help me.
Thanks.
In B1 Cell of Sheet2
=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,FALSE),"")
Drag it down…
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Strange...! it works in my sample sheet but not in my project sheet..! it is not finding the values from first sheet!!
What result are you getting if you apply the below part alone by ignoring the iferror part
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)
I am getting #N/A..
But the value is available in first column of the first sheet!!
Check whether is there any extra spaces...
Yep it showed the values after savingThanks
May be the calculation mode is in Manual Instead of Automatic.
Change it to Automatic if needed.
Or press F9 to calculate the workbook manually.
Yes you are correct.. It was set to manual before..!
Last edited by szpt9m; 11-19-2013 at 06:34 AM.
Glad you fixed it and thanks for the feedback
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks