Forum Discussion
Return value next to cell with multiple source arrays
Hi! This seems like a simple problem but I cant figure it out. So I have two tables with different values. I want to inspect the lower rows of the both tables (highlighted with grey) and find...
=IFERROR(IF(NOT(ISNA(INDEX(E9:N9,(MATCH(C2,E10:N10,0))))),INDEX(E9:N9,(MATCH(C2,E10:N10))),INDEX(E3:N3,(MATCH(C2,E4:N4,0)))),"not found")
Is this what you are looking for?