Forum Discussion

Brass Contributor

Nov 11, 2021

Match two columns against other two columns and populate cell

I would like to match rows D4 & E4, against rows B5 & C5. If they match, I need cells D5 & E5 to populate cell A5 (API#) Please can someone help?

Bronze Contributor

Nov 12, 2021

=FILTER($A$5:$A$7,($B$5:$B$7=D2)*($C$5:$C$7=E2))

cheers