Hi guys,
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".
So.....
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 :
C2 YES
C3 YES
C4 YES
C5 TBC
C6 YES
C7 YES
C8 YES
C9 TBC
C10 YES
C11 YES
C12 TBC
C13 TBC
C14 TBC
C15 TBC
C16 YES
C17 TBC
C18 TBC
C19 YES
C20 YES
C21 TBC
Any help would be most appreciated!
Thanks in advance
Richard
Bookmarks