Conditional Values
Hello. I am trying to merge two spreadsheets with item names and quantities. The problem is that the destination sheet has 400 items and the Donor worksheet has only 100 of those items. In DestWS I need to to insert a value from ColumnB in DonorWS into a cell if the item names match. In beginner Excel I would say “IF(Sheet2!A2=Sheet1!A2,Sheet2!B2,0). This doesn’t work, it doesn’t check to make sure that the value in A2 is the same in both sheets. Thanks for any help!
Possibly?
=INDEX(Sheet2!B:B,MATCH(Sheet1!A2,Sheet2!A:A,0))
or
=VLOOKUP(Shee1!A2,Sheet2!A:B,2,FALSE)
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 liveisgood and welcome to the forum,
See the attached sample workbook with what I think you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks