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 11, 2021

I don't know if I understood it correctly

=IF(ISERROR(LOOKUP(CONCAT($B5:$C5),CONCAT($D4:$E4),2)),"Not found","API#"&ROW())