|COLUMN A||COLUMN B||COLUMN C||COLUMN D||COLUMN E||COLUMN F||COLUMN G|
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.