Hi. I would like to compare three columns (column b,d,e) which are not together in one sheet (sheet 1)with another three columns (columns b,d,e) in another spreadsheet (sheet 2), and if the values match, extract the corresponding value from column f in sheet 2 and paste in column g of sheet 1.
in G2 of sheet1:
=INDEX(Sheet2!$F$2:$F$9,MATCH(B2 & D2 & E2,Sheet2!$B$2:$B$9 & Sheet2!$D$2:$D$9 & Sheet2!$E$2:$E$9,0))
ARRAY-ENTERED with Ctrl+Shift+Enter (not just Enter), then copy down.
See attached.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.