Vlookup
Try using ISNA instead of ISERROR
--
If my posting was helpful, please click the "Yes" button.
ROCK ON!,
Scott
"FP Novice" wrote:
I would like this string to return "not equiped" when an empty cell is
encountered.
I have tried multiple changes and still I only get a "0" returned. Any help
would be appreciated.
Here is my string:
=IF(ISERROR(VLOOKUP($B6,'Table
1'!$A6:$G$14988,3,FALSE)),"",VLOOKUP($B6,'Table 1'!$A6:$G$14988,3,FALSE))
|