Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
[color red]Microsoft Excel: VLOOKUP with ERROR.TYPE = 7
Many Thanks. Should have looked for another Excel function to handle the N/A. Works like a champ. GQ$MOOTH- GQSMOOTH
- Post #3
- Forum: Microsoft: Office
-
[color red]Microsoft Excel: VLOOKUP with ERROR.TYPE = 7
I am using the following formula in my spreadsheet calculation. =IF(ERROR.TYPE((VLOOKUP(E3,Everything_5s,6,FALSE)/$M3))=7,0,(VLOOKUP(E3,Everything_5s,6,FALSE)/$M3)) Basically, I want to be able to display, 0 or the actual value based on two scenarios. If the value does not exist in my...- GQSMOOTH
- Thread
- Replies: 2
- Forum: Microsoft: Office
