I need to compare cells in column B and B in sheet one to cells in column A and B in sheet 2, if items match then I need column C from sheet 2 copied to sheet one column D. I have used VLookups to compare one item and pull it over (=VLOOKUP(B2,Sheet2!A:C,3,FALSE)) but not two. Is this possible or is there a better option to do this?
Last edited by herbie000; 06-17-2020 at 12:07 PM. Reason: add file
The yellow banner at the top of the forum explains how to upload a file.
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.
Hi
In D2
=IFERROR(INDEX(Sheet2!C:C,MATCH(B2&C2,Sheet2!B:B&Sheet2!A:A,0)),0)
I have not locked any of your columns since the formula is only going down.
Workbook attached.
Using INDEX MATCH as an alternative as it is a bit more flexible than vlookup.
If you like my answer please *Add Reputation
That works perfect! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks