Posted to microsoft.public.excel.misc

Steve

external usenet poster

Posts: 1,814

Lookup question

I want to be able to take the value of A2, and lookup in a range of cells on
another sheet, and if it finds the value of a2 in that range, then display
"open". If it doesn't find the value of A2 in the range, I want it to
display "closed". Is it possible to make this happen?

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
Lookup or If, then Question	Stephanie	Excel Discussion (Misc queries)	1	June 24th 08 12:10 AM
Lookup Question	CB	Excel Worksheet Functions	5	February 29th 08 05:52 PM
LOOKUP QUESTION	kahuna	Excel Discussion (Misc queries)	1	June 29th 07 11:20 AM
LOOKUP Question	shakey1181	Excel Discussion (Misc queries)	4	May 31st 06 01:59 PM
LOOKUP question	DJ	Excel Worksheet Functions	5	October 11th 05 02:01 AM

All times are GMT +1. The time now is 04:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us