Thread: Compare & Write
View Single Post
 
Old 04-20-2018, 12:18 AM
DaRTHY DaRTHY is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Apr 2018
Posts: 2
DaRTHY is on a distinguished road
Default
Thank you for your answer. But it is not working like that. I need to see there Darth Vader. I did your code like this:

Code:
=IF(ISNA(VLOOKUP("Darth Vader";B4:B500;1;FALSE));"No Match";"Darth Vader")
and i got no match.
Reply With Quote