check if a value exists within a lookup range?

[wwj]

If the value in A276 does not exist in the lookup range (GRUG_List_v1_2025!$A$2:$A$363), the VLOOKUP function will return a #N/A error.
Solution: Use the IFERROR function to handle the error:

Code: Select all

=IF(IFERROR(VLOOKUP(A276,GRUG_List_v1_2025!$A$2:$A$363,1,FALSE), "")=A276, "Yes", "")