Hi all,
Might anyone be able to assist here please I have 3 formulas each returning #N/A if the data is not found can anyone amend this to show blank rather than #N/A if the data is not found,
I have tried but I keep getting the same error,
Thanks in advance,
Might anyone be able to assist here please I have 3 formulas each returning #N/A if the data is not found can anyone amend this to show blank rather than #N/A if the data is not found,
I have tried but I keep getting the same error,
Thanks in advance,
Excel Formula:
=IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes","")
Excel Formula:
=IF(C12="YES",IF(F12="YES","Available",""),"")
Excel Formula:
=IF(G12="Available",A12,"")