IF Formula/ Countif

[Skeen]

I have the below formula I am trying to use to let me know if a person is supposed to be making specific adjustments. Right now every cell is showing "Check Adjustment" and the ones that are allowed to make adjustments are showing their names. I am wanting the cells to be blank if not an "RV" adjustment, but if it is an RV adjustment check a list, if they are not on the list it should say "Audit". Please let me know if you can help!!

=IF($A4="RV",VLOOKUP(V4,'RV Adjustments'!A:B,1,FALSE),"Check Adjustment")

Also I have a COUNTIF formula and it is giving the correct results, just wondering if there is a way for the formula not to produce "True" or "False" but instead "Audit".

 

[AlanY]

try

=IF($A4="RV",if(iserror(VLOOKUP(V4,'RV Adjustments'!A:B,1,FALSE),"Audit","Check Adjustment"),"")

 

[Skeen]

It tells me there are too many arguments...

 

[AlanY]

sorry, my bad

=IF($A4="RV",if(iserror(VLOOKUP(V4,'RV Adjustments'!A:B,1,FALSE)),"Audit","Check Adjustment"),"")

 

[Skeen]

That worked however, it is showing "Check Adjustment" for all RV Adjustments. I only want it to say check adjustments if a person's name is Not on the list I have.

 

[AlanY]

ok

if a person's name is Not on the list > "Check Adjustment"
what if the name is on it?

and when $A4 is not "RV"?

 

[Skeen]

Correct, if they are not on the list "Check Adjustment", if they are on the list the adjustment does not need to be checked. And when A4 is not RV it needs to be blank. There are several different adjustments that would be listed in A4

 

[AlanY]

ok, may be

=IF($A4="RV",if(iserror(VLOOKUP(V4,'RV Adjustments'!A:B,1,FALSE)),"Check Adjustment",$A4),"")

 

[Skeen]

That works great!!! Thanks so much!
Do you know if I can fix the Countif formula? I have a COUNTIF formula and it is giving the correct results, just wondering if there is a way for the formula not to produce "True" or "False" but instead "Audit".

 

[AlanY]

what's the countif() looks like?