Index and Match with OR

[Michelle Mitchell]

Hello all. My name is Michelle and I am brand new to this forum. I just joined because found this to be a great site for finding answers to questions so here goes my 1st question. I am trying to match values in one column to values from multiple tables and it is not working. Here is what works when looking for a match from one list: =INDEX(BG:BG,MATCH(BM13,BC:BC),0). I find the match in column BC and it returns the value in column BG. My problem: I also want to look in column AW and return the value in column BA if the match is found there instead. I have used the or statement but get an error. Here is the syntax: =INDEX (OR(BG:BG,MATCH(BM13,BC:BC),0),(BA:BA,match(BM13,AW:AW),0)) Can someone help me? Thank you in advance.