Hello. Please see the attachment. In Sheet 1 I have a list of different categories. Sheet two has the category ID numbers. Is there a formula that will pull from sheet 2 the category id to sheet 1? The only issue is they are not in the same sort order.
Put this in C2 and copy down:
=IF(B2="", "", VLOOKUP(B2, Sheet2!A:B, 2, 0))
You will see an #N/A error when there is no match. Just add new items to the table on Sheet2 for each NA you see and all of those will correct at once.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Works great thank you. But when I try to edit my worksheet it doesn't work for me. Please see the attachments. Please note that the sheet1 has the text in in column F and on sheet2 this other info needed is in column b and c. I have tried to edit this on my own but i keep getting N/A
If the formula above I gave you was to go in cell C2 and it clearly references the cell next to it (B2), and compares it to columns B:C of a sheet named Sheet2, then what would YOU change the formula to go in G2 (not G1) and look at cell F2 and compare to columns B:C on a sheet named Sheet2?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks