I am currently running a spreadsheet which has an IF statement which also uses ISNA & MATCH. The formula is working fine bit i would like to adapt it slightly to include a couple of other statements - I thought it would be quite a simple one at first with a nested IF statement but am having difficulties with it - wondering if any of you can help?
I have attached a simplified version of my sheet.
I would like column C to display TBC or YES depending on the conditions.
As it is the column will display YES if the name in column A matches one of the names in column E.
However i would also like C to display YES if the Role column (B) is populated (regardless of whether the corresponding name in A is in E) with any text UNLESS it says "Hunter".
If A is in the the range E:E then C = YES OR if B = any text (with the exception of "Hunter") then C = YES.
If A is NOT in the range E:E AND B = blank or "Hunter" then C = TBC.
I hope that makes sense!
In the sheet attached the results for C2 to C21 should come out as :
Any help would be most appreciated!
Thanks in advance