Thread: [Solved] Help with Excel Formula
View Single Post
 
Old 11-24-2021, 12:58 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Arvi, I think there is a flaw in your answer.
The text returned by the VLOOKUP will ALWAYS be larger than the null text string. The formula seems to return "yes" always
Perhaps
Code:
=IF(countif('CPU Database'!$A$2:$A$44,$a2),"yes","no")
Reply With Quote