Sep 17 2022 10:54 AM
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 the search array I need a "No Photo", if it is I need a "Yes Photo.
I see custom numbers in the aray and can get "Yes Photo" but I also get "Yes Photo" when I physically verify.
formula as typed =IF(ISNA(VLOOKUP(D1,'Silhouette Master List'!C$1:C$1082,FALSE)),"No Photo","Yes Photo")
same results if edited as =IF(ISNA(VLOOKUP(D1,'Silhouette Master List'!C$1:C$1082,TRUE)),"No Photo","Yes Photo")
Been working for over 24 hours in a critical short deadline situation.
Sep 17 2022 11:08 AM
Your VLOOKUP() is missing the third argument (column index number).
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Sep 17 2022 01:19 PM
@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.
Sep 17 2022 01:32 PM
In VLOOKUP(D1,'Silhouette Master List'!C$1:C$1082,FALSE), VLOOKUP has 3 arguments:
Your lookup range has only one column, and FALSE should be the 4th argument, not the 3rd one...
Sep 17 2022 02:57 PM
Sep 17 2022 03:16 PM
You just want to check whether a value is in a list.
=IF(COUNTIF('Silhouette Master List'!C1:C$1082,D1);"Yes Photo";"No Photo")
Sep 17 2022 03:30 PM