Forum Discussion

sbishop785's avatar
sbishop785
Copper Contributor
Apr 03, 2024
Solved

RE: Help with rewriting expression to exclude #N/A

Hi there Microsoft Community!!!

 

I'm a bit of a noob to excel, but I'm trying to create something for our org.

The excel sheet below grabs values from a separate sheet using this expression: 

=VLOOKUP(H5,'Video Overview'!B:D,2,0)


I'm stuck with how to write an expression that doesn't show the #N/A, can someone help?

I tried the following with no success:

=IF(VLOOKUP(H5,'Video Overview'!B:D,2,0)=0,"",VLOOKUP(H5,'Video Overview'!B:D,2,0))
=IF(VLOOKUP(H5,'Video Overview'!B:D,2,0)=#N/A,"",VLOOKUP(H5,'Video Overview'!B:D,2,0))





Resources