Forum Discussion
Solved
Excel formula for ISNUMBER and VLOOKUP returning wrong value
Hello awesome Excel users. I have been using ChatGPT to create a formula and I can't seem to get it quite right. To begin with, here is an example of test data I am working with in columns A B and C...
VLOOKUP() does not return a number for the criteria in column A.
So ISNUMBER() will always be FALSE.
=IF(COUNTIFS($C$2:$C$4,A2),"Yes","No")
VLOOKUP() does not return a number for the criteria in column A.
So ISNUMBER() will always be FALSE.
=IF(COUNTIFS($C$2:$C$4,A2),"Yes","No")
That worked brilliantly, thank you!