Forum Discussion
Trouble with an =IF(ISNA(VLOOKUP Formula
Your VLOOKUP() is missing the third argument (column index number).
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Detlef_Lewin It has the 3rd argument in the form of C1:C1082 from the Silhouette Master. The issue is when I go into verify a custom number from the LookUp sheet on the Array sheet and the custom number is not there, and I should be receiving a "No Photo" as my result of the lookup, but I am not, it states "Yes Photo". There are other custom numbers in the lookup that are also on the array and they are coming up as "No Photo" and should be coming up as "Yes Photo". I wish I could attach the images I captured of the lookup and the array from my computer screen.
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.
