COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | COLUMN F | COLUMN G |
ALPHA | =IF(COUNTIF(A:A,B2)>0,"B","A") | 1 | 13 | 0 | 0 | |
BRAVO | ALPHA | =IF(COUNTIF(A:A,B3)>0,"B","A") | 2 | 5 | 1 | 13 |
CHARLIE | =IF(COUNTIF(A:A,B4)>0,"B","A") | 1 | 8 | 0 | 0 | |
DELTA | ALPHA | =IF(COUNTIF(A:A,B5)>0,"B","A") | 5 | 15 | 0 | 0 |
Above is a small extract of data.
I would like to expand the formula in column C to compare the data in columns b, f, g with the data held in column a, d, e for the corresponding line stated in column B
for example using the bravo row I am looking for a the following options - A (NO MATCH), B (COMPLETE MATCH), C (PARTIAL MATCH)
if column B is blank I want a response of A
if column B has a value which appears in column A on any row I would like to check the value in (bravo, column f) for a match with the corresponding information in column d.
so using the Bravo Line - Alpha appears in column B - I would like to check the information in cell f3 with the data stored in cell d2 to see if it matches, if it does I would like a cell c to show a value of B for a full match and a value of C if a partial match
I would appreciate any help or suggestions.