Posted to microsoft.public.excel.misc

sross002

external usenet poster

Posts: 29

vlookup + if formula help!

THANKS!

"×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ" wrote:

In cell B1 of Sheet1 try the formula:
=IF(ISNA(MATCH(A1,Sheet2!A:A,)),"YES","NO")
Micky

"sross002" wrote:

I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1)
matches any of those names then I want it to say "NO" in cell a2 (sheet1).
if it doesn't match then I want it to say "YES" in cell a2 (sheet1).

I'm assuming it is a combination of a "vlookup" and a "if" formula, but I
can't right it out. Please help.

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 formula	David Ryan	Excel Worksheet Functions	2	November 22nd 09 11:36 PM
How do I combine a VLOOKUP formula and a NETWORKDAYS formula?	Tracy	Excel Worksheet Functions	2	October 15th 09 04:14 PM
Alternative formula to the vlookup formula?	Victor	Excel Worksheet Functions	2	May 12th 08 04:38 PM
convert vlookup formula to link formula	AFA	Excel Worksheet Functions	0	February 20th 08 04:24 AM
Excel 2002 VLOOKUP formula or other formula	Serge	Excel Discussion (Misc queries)	4	February 26th 07 03:56 PM

All times are GMT +1. The time now is 06:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us