Posted to microsoft.public.excel.worksheet.functions

Lighthouseman

Posts: n/a

Elements and Arrays in Excel

Is there a simple way to determine if a cell value is an element of an array?
I've tried Lookup, Vlookup, Match to no avail. They return false positives or
#N/A errors due to the way they test for matches. I posted this message a few
moments ago, somewhere, but it went to never-never land, I'm afraid.

Norm

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
Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more	R	Excel Worksheet Functions	3	November 18th 05 06:38 AM
Need to derive combinations for 4 elements each with 3 possible va	LAdekoya	Excel Worksheet Functions	4	November 8th 05 12:26 PM

All times are GMT +1. The time now is 02:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us