function help with an countif statement

[mort1703]

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.

 

[Fluff]

Duplicate to: function help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.