I hope I can make this clear...

I have a range of data in a drop down box that enters into column G, then generates a vlookup for column K of N or R or blank. However if column R has data = YES then column K must = N and I have worked a formula for this, BUT if one particular piece of data (one of the same incident) in column G is there then column K must stay blank even if column R = yes.

I have got an if formula that works if the G data (one of the same) and the R data (YES) are the same but that overides the ability to force the K column to N for all other data.

I essentially have to have a formula that allows multiple conditions is that right?

happy to upload the sheet if it helps

cheers