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".
=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".
