LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bullman
 
Posts: n/a
Default Check if cell entry belongs to a name list-how?

Hello

I have only started to use and realise the power of using named lists
to represent a range of values. I am sure it is a simple thing to do,
but what is the easiest logical formula test that will look at a cell
and return a TRUE value if the entry in the cell belongs to a
pre-defined named list and a FALSE value if it does not.

Thanks in advance

Bullman

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Return entry in column above/below cell TheRobsterUK Excel Worksheet Functions 2 November 17th 05 03:34 PM
How to create a List inside a cell? Msantos Excel Discussion (Misc queries) 6 September 13th 05 12:05 AM
Ooh .. Linking a list to a list to an output cell StrawDog Excel Discussion (Misc queries) 4 August 22nd 05 09:51 PM
resolving a numeric cell entry for its meaning vtcrob Excel Worksheet Functions 0 February 4th 05 02:23 AM
Move the last entry in a column to a different cell, when the loc. MicroSoft Excell (?) Excel Worksheet Functions 2 January 7th 05 09:29 PM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"