Forum Discussion
sbishop785
Apr 03, 2024Copper Contributor
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))
2 Replies
Sort By
- Harun24HRBronze Contributor
- sbishop785Copper Contributor
Harun24HR you're the best! thanks!!!