Forum Discussion
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?
4 Replies
I don't know if I understood it correctly
=IF(ISERROR(LOOKUP(CONCAT($B5:$C5),CONCAT($D4:$E4),2)),"Not found","API#"&ROW())- By the way, just to clarify and may be useful later.
Technically D4, E4 and so on, they are not rows, they are cells.
1, 2, 3, 4 they are rows. On the other hand, A, B, C, D they are columns.
From the intersection of these rows and columns, cells originate, which we call D4, E4, etc.
I hope this clarification will be helpful to you. - Hi good day.
You can detail your query a little more please, to be able to help you.
What should appear in D5 if B5 matches D4? and the same for E5.
And how does A5 content come about?
