Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 107

need a search/find/lookup function

I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.

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
Search / Find Function	Harry C.	Excel Worksheet Functions	6	June 16th 09 05:40 PM
Find / Search Function	Andrew	Excel Discussion (Misc queries)	1	October 12th 08 08:25 PM
Search, find or lookup defined text in text string	zzxxcc	Excel Worksheet Functions	9	September 6th 07 09:37 PM
Find & Search Function	drvortex	Excel Worksheet Functions	6	June 16th 06 08:34 PM
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA	hsg	Excel Worksheet Functions	2	November 18th 04 07:24 AM

All times are GMT +1. The time now is 03:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us