PDA

View Full Version : Compare and extract column



salih129
10-17-2013, 04:39 AM
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.

I have attached a file. Please Help. Thanks

p45cal
10-17-2013, 06:10 AM
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.

salih129
10-17-2013, 06:56 AM
Many thanks for your help. It works well. Thanks again.