Formula IFERROR then Blank

[pure vito]

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,

=IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes","")

=IF(C12="YES",IF(F12="YES","Available",""),"")

=IF(G12="Available",A12,"")

 

[Peter_SSs]

Instead of
=YourExistingFormula

try
=IFNA(YourExistingFormula,"")

 

[pure vito]

Hey Peter,

Thanks for taking the time, I'm still getting the same error "You've entered too many arguments"

 

[Peter_SSs]

I'm still getting the same error "You've entered too many arguments"

Doesn't seem like the same error to me - in post 1 you said the error was #N/A.

 

[Peter_SSs]

Isn't this what you want?

23 01 18.xlsm
	B	C
12	#N/A
Sheet5

Cell Formulas
Range	Formula
B12	B12	=IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes","")
C12	C12	=IFNA(IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes",""),"")

 

[pure vito]

Sorry peter I just stated in the 1st post that if the data was not found it would return #N/A,

I have just tried the formula unfortunately is does not return "Yes" everything remains blank

The image is with the original formula

 

[Peter_SSs]

Your image is only of one sheet when it seems three are involved. Further, we cannot copy from an image. Please consider XL2BB for some varied but realistic sample data and expected results that we can copy from for testing.

Here are my sheets

pure vito.xlsm
	C
1	XXX
Rolecheck

pure vito.xlsm
	C	D	E	F
1		WWW	XXX	YYY
2	Fred		Yes
3	Tom
4	Bobby		Yes
Available

This sheet below has your formula in column B and mine in column C.
What parts of this last sheet in column C are wrong and what is wrong with them?

pure vito.xlsm
	A	B	C
12	Fred	Yes	Yes
13	Ken	#N/A
14	Bobby	Yes	Yes
15	0	#N/A
Sheet5

Cell Formulas
Range	Formula
B12:B15	B12	=IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes","")
C12:C15	C12	=IFNA(IF(VLOOKUP(A12,Available!$C$1:O110,MATCH(Rolecheck!$C$1,Available!$C$1:$O$1,0),0)="Yes","Yes",""),"")

 

[pure vito]

Again thank you peter for taking the time to do this and apologies for the lack of XL2BB my work computer does not allow me to install this,

So the issue is where column A15 is showing 0 column B15 shows #N/A is there a way to have this show blank also?

The problem for me is that I am populating a list box within a user form and the #N/A shows up in that data

 

[Peter_SSs]

So the issue is where column A15 is showing 0 column B15 shows #N/A is there a way to have this show blank also?

Yes, use the formula that I have shown in column C.

 

[pure vito]

Launch Holiday Tracker 2023 V1.2 vito.xlsm

I Must be doing something wrong here Peter it's still removing the "yes" for me,

I have attached my document if it helps