Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default Matching cell

I have a value in one cell and i want to see if it appears
in a list and for excel to display a true or false
statement how do i do this?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 391
Default Matching cell

Use the worksheet MATCH() function


Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
I have a value in one cell and i want to see if it

appears
in a list and for excel to display a true or false
statement how do i do this?
.

Reply
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
How to find next up matching cell? DevourU Excel Worksheet Functions 0 March 3rd 10 05:20 PM
matching cell values Geofridu Excel Worksheet Functions 2 September 25th 08 06:49 PM
find cell with matching text, then reference cell in same row [email protected] Excel Worksheet Functions 2 October 20th 07 01:05 AM
Matching more than one cell JHalsall Excel Discussion (Misc queries) 3 June 26th 06 11:24 AM
Matching data and linking it to the matching cell yvonne a via OfficeKB.com Links and Linking in Excel 0 July 13th 05 07:30 PM


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

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

About Us

"It's about Microsoft Excel"