Help with Excel Formula

ArviLaanemets · #4 11-24-2021, 01:36 AM

Quote:

Originally Posted by Pecoflyer

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula - Help	guiverdi	Excel	2	07-23-2017 11:48 PM
excel if formula	LPerry	Excel	2	03-06-2017 07:14 AM
excel formula	jcaal50	Excel	6	05-16-2014 04:01 PM
excel help Formula	sellspeed	Excel	15	03-10-2010 10:57 AM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM