I'm having a really hard time using the Match function on multiple rows of a second sheet1. I'm building a table on sheet2 that I want to auto populate an "X" in it if Row 1 and column A have matched up in sheet1. I have concatenated column A with column B to make column D in sheet1. I have also concatenated column A with column C to make column E in sheet one. I want to write a formula in sheet2 that allows me to see if the combination of row 1 and column A in sheet 2 are in either column C or D in sheet 1. Basically It would look like:
I can search one column just fine with something like: =MATCH($A2&B$1,Sheet1!$D:$D,0)
My question is how can I put another match function in the formula so that it also searches column E in sheet1 and that I will get a "1" on column C row 2 in sheet 2?
Bookmarks