Thread: [Solved] Help with Excel Formula
View Single Post
 
Old 11-24-2021, 01:36 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Pecoflyer View Post
The text returned by the VLOOKUP will ALWAYS be larger than the null text string. The formula seems to return "yes" always
It works for me!

No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
Yes i3-9300 Yes
Yes i3-9320 Yes
Yes i3-9350K Yes
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A
No #N/A #N/A

1st column is returned by actual formula;
2nd column is returned by VLookup();
3rd column is returned by If().

With 4th parameter 0/False, VLOOKUP returns #N/A always, when no exact match was found!
Reply With Quote