Hi,
I’m trying to compare two sheets. On both sheets are product codes (both in column A) of which some are matching. When a product code matches I want the adjacent cell on sheet 2 (column B, price) to be copied to the column C on sheet 1 (in the same row as the matched name).
I have searched quite a lot to find a (suitable) solution but I have failed so far.
Thanks in advance.
Best regards
Maarten
You can use VLOOKUP or SUMIF
e.g
=IFERROR(Vlookup(A2,'Sheet2'!A:B,2,FALSE),"")
or
=SUMIF('Sheet2'!A:A,A2,'Sheet'!B:B)
The Vlookup finds the first (and if unique, only) match. If not found it returns a blank.
The Sumif finds all matches (and if unique, only match). If not found it returns a 0.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
You need to use VLOOKUP() in Sheet1 column C. e.g.
obviously change the B100 to cover your actual range in sheet2.
Please Login or Register to view this content.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you both, I had already tried vlookup but I made an error in the table array. Now it works!
Best regards
Maarten
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks