Hey guys, Im having trouble setting up an index match that searches 1 value across multiple columns. Attaching an example spreadsheet.
Thanks for the help
Column A Column B Column C
a e 1
b f 2
c g 3
d h 4
Basically want to do an index match that searches any letter from column A&B and returns the number on C. I tried =INDEX(C2:C5,MATCH(F2,A2:B5,0)) where F2 has the desired letter
Bookmarks