| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Text with List
Hi, I would like to check a cell to see if the name in it matches one of the
names in a list. If so, I would like to print the name in the cell containing the formula. If not, I would like to print something else, like "False". Is this possible? Thanks, Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match Text with List
With name list in ColA and query name in cell B1 try the below formual in
cell C1. =IF(ISNA(MATCH(B1,A:A,0)),"False",B1) -- Jacob "tommcbrny" wrote: Hi, I would like to check a cell to see if the name in it matches one of the names in a list. If so, I would like to print the name in the cell containing the formula. If not, I would like to print something else, like "False". Is this possible? Thanks, Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find closest text match for each unique entry in a list | Excel Discussion (Misc queries) | |||
| match and list | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Product list to match price list | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
