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?
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?
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?