Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 718

Vlookup returning a YES or NO

Hello

I'd like to return a yes or no response.
at the moment only the YES is working.
Can anyone give me a tip?
Thanks
Rob

=IF(A6=VLOOKUP(A6,'[Catalogue Robs Test Stock
Range.xls]Catalogue'!$1:$5000,1,FALSE),"YES","NO")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP always returning the same value!	Jennifer Cali	Excel Discussion (Misc queries)	10	April 23rd 23 09:08 AM
VLOOKUP Keeps Returning #N/A	Ric_M	Excel Worksheet Functions	7	April 27th 13 12:10 PM
Vlookup Returning #n/a	Toolbar Confused	Excel Worksheet Functions	4	July 5th 07 01:32 AM
vlookup returning sum	Rose	Excel Worksheet Functions	1	July 14th 05 10:47 PM
Vlookup and returning #n/a	Cathrine	Excel Worksheet Functions	3	December 23rd 04 02:23 PM

All times are GMT +1. The time now is 08:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us