Return blank value instead of #N/A

[TomNR]

Hi all,

I am having difficulty removing the #N/A value when I run this formula:

=IF($O4='2'!$L$2, VLOOKUP($B$1,Week2[[Name]:[Saturday ]],5,FALSE), "")

As you can see I can't use the IFERROR or IFNA option as I am already querying =IF($O4='2'!$L$2

Does anyone know how I can just have a blank value instead of #N/A?

Thank you all in advance!

 

[Naresh Yadav]

Hi TomNR,
can you share your excel file where you are getting error while applying your formula

 

[TomNR]

Hi TomNR,
can you share your excel file where you are getting error while applying your formula

Sure thing, I have highlighted the column specifically I am referring to but if it could apply to all of them then that would be great!

 

[mohadin]

Hi
try this method
= iferror(your formula with N#A return);"")

 

[mohadin]

is this what you want?

 

[Naresh Yadav]

Hi TomNR,


I think the reason behind getting error that your vlookup
formula not finding the B1 Value(Template) in your given range Week2[[Name]:[Saturday when your ccondition $O4='2'!$L$2 is tru

try this one..

=IF($O4='2'!$L$2, IFERROR(VLOOKUP($B$1,Week2[[Name]:[Saturday ]],5,FALSE),""),"")

 

[Naresh Yadav]

pls find attached file..

 

[TomNR]

is this what you want?

Perfect!!!

That is exactly what I was after, such a simple solution!

Thank you so much!

 

[TomNR]

pls find attached file..

Yes, very similar to mohadin's solution, works perfectly and exactly what I was after!

Thank you both, again just needed fresh eyes on this one and just proved why I love this community so much!

Thanks again!

 

[mohadin]

I'm so glad I could help