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