Forum Discussion
Trouble with an =IF(ISNA(VLOOKUP Formula
I have with multiple sheets in a workbook with unique custom number (0000000000) and trying to verify if the main sheet array has that same custom number. If the custom number is not available in th...
In VLOOKUP(D1,'Silhouette Master List'!C$1:C$1082,FALSE), VLOOKUP has 3 arguments:
- D1
- 'Silhouette Master List'!C$1:C$1082
- FALSE
Your lookup range has only one column, and FALSE should be the 4th argument, not the 3rd one...
Hans,
I think I got it, based on your suggestion of the 4th argument. The Conditional Formatting is now lighting up Red for "No Photo". Thank you so very much.
I think I got it, based on your suggestion of the 4th argument. The Conditional Formatting is now lighting up Red for "No Photo". Thank you so very much.