formula to compare columns and if equal then copy specific cell into another cel
ID: 638020 • Letter: F
Question
formula to compare columns and if equal then copy specific cell into another cell
Example:
Column A Column B Column C
A1: Meeting B1: 1 C1: ___________
A2: Meeting B2: 2 C2: Run
A3: Meeting B3: 3 C3: Present
A10: Meeting B10: 1 C10: Discuss
A11: Meeting B11: 3 C11: Present
A12: Meeting B12: 2 C12: Run
A13: Booth B13: 1 C13: Confirm
A14: Booth B14: 2 C14: Confirm
If I enter in Meeting in cell A1, I want the formula to look and find from the table below (A10:C14) what meets the criteria of A1 and B1 and put what is on the same row in Column C into C1. For example, I enter in Meeting in A1, it see's Meeting in A10:A12, then checks column B and see's only B10 equals B1, then copies C10 into C1.
Any help would be greatly appreciated. If you need more explanation please let me know.
Thanks !!
Explanation / Answer
Hi..
Put this in C1 and drag down :
=IFERROR(LOOKUP(2,1/(($A$10:$A$14=A1)*($B$10:$B$14=B1)), $C$10:$C$14),"No Match")
If you want a blank instead of No match if there isn't a match you can use
=IFERROR(LOOKUP(2,1/(($A$10:$A$14=A1)*($B$10:$B$14=B1)), $C$10:$C$14),"")
Or put anything you want between that last quotes.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.