Hi Guys,
Thanks once again. New Job and I didn't know I'd need so much excel.
Basically I need to look at two cells E2, and F2 and where you find both together in a row as part of column A and B then return C. I need it to also be capable of approximate matches.
Example below for reference.
Searching E2 (AA) in column A and F2 (YY) in column B should match 3 rows and return 3 YES's (YES 1, YES 2, YES 3) one after the other in E3-E5. I need it capable of approximate match because of examples like row 5.
The real data is a lot more complicated with over 3000 rows. If you can help me with an easy fill down formula I'd be ever appreciative.
<tbody>
</tbody>
Thanks once again. New Job and I didn't know I'd need so much excel.
Basically I need to look at two cells E2, and F2 and where you find both together in a row as part of column A and B then return C. I need it to also be capable of approximate matches.
Example below for reference.
Searching E2 (AA) in column A and F2 (YY) in column B should match 3 rows and return 3 YES's (YES 1, YES 2, YES 3) one after the other in E3-E5. I need it capable of approximate match because of examples like row 5.
The real data is a lot more complicated with over 3000 rows. If you can help me with an easy fill down formula I'd be ever appreciative.
A | B | C | D | E | F | |
1 | Name 1 | Name 2 | Name 1 | Name 2 | ||
2 | AA | XX | No | Search: | AA | YY |
3 | AA | YY | YES 1 | Result 1: | ||
4 | AA | YY | YES 2 | Result 2: | ||
5 | AA 1 | YY 1 | YES 3 | Result 3: | ||
6 | AA | ZZ | No | Result 4: | ||
7 | AA | ZZ | No | Result 5: | ||
8 | AA | ZZ | No | |||
9 | AA | ZZ | No | |||
10 | BB | XX | NO | |||
11 | BB | YY | NO | |||
12 | BB | YY | NO | |||
13 | BB | XX | NO |
<tbody>
</tbody>