LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default A excel function similar to ListFind()

Hi. I am trying to write a function that compares the value of a cell to a
pre-defined list, and renturns a result of any description.

For example. I have a colum of 1000 random words. I want to show next to the
column whether one of these words match.

I have tried: Find and Search.

I nearly was able to do it, but my list was too long for the formula.

Can I reference the list of values to mach, and get the formular to look
there.

Please say this is possible...

M@)
 
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
formula similar to "countifs" function in excel 2007 embee Excel Worksheet Functions 2 April 19th 10 05:19 PM
In Excel, can I use the VALUE() function or similar for text? malcolm Excel Worksheet Functions 0 June 18th 08 12:10 AM
similar function for SUBSTITUTE in excel? neb Excel Discussion (Misc queries) 3 September 8th 06 10:46 AM
Excel needs an AVERAGEIF function similar to SUMIF. Please! Roseland Excel Discussion (Misc queries) 1 May 16th 06 02:22 PM
Help with Similar MOD Function Please Paul Black Excel Programming 11 December 5th 04 10:26 PM


All times are GMT +1. The time now is 10:59 PM.

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"