Forum Discussion
Comparing data to return a value
Hi,
I have 5 columns of data. If A and B match E and F, I want the code in G to appear in C. Please can someone help with the formula?
Many thanks,
Emma
A
B
C
D
E
...
Sorry about that!
Please use this formula instead:
=INDEX($G$2:$G$13,INDEX(MATCH(A2&B2,$E$2:$E$13&$F$2:$F$13,0),))
Please find the attached file.
Brilliant! Thank you!
Haytham Amairah wrote:
Sorry about that!
Please use this formula instead:
=INDEX($G$2:$G$13,INDEX(MATCH(A2&B2,$E$2:$E$13&$F$2:$F$13,0),))Please find the attached file.