Posted to microsoft.public.excel.misc

Max

external usenet poster

Posts: 9,221

Lookups?

In Sheet2,
In say, W9: =IF(COUNTIF(Sheet1!B:B,G9),"New","")
That should do it ok. Success? hit the YES below, let me know
--
Max
Singapore
---
"lightbulb" wrote:
This did not work. I want it to say new in column W of sheet 2 if G9 on
sheet 2 appears anywhere in column B on sheet 1. More help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Lookups???	KevinUPS	Excel Worksheet Functions	2	September 15th 08 07:50 PM
Lookups	Sarah at DaVita	Excel Discussion (Misc queries)	4	September 3rd 08 01:53 AM
lookups	JoviGirl	Excel Worksheet Functions	4	August 27th 08 05:32 PM
Lookups or something	ConfusedNExcel	Excel Worksheet Functions	0	April 3rd 07 09:30 PM
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied.	Mr Wiffy	Excel Worksheet Functions	2	May 16th 05 04:29 AM

All times are GMT +1. The time now is 11:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us