| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Searching Excel for a value
If column A and column B both contain a list of names, what formula con I put
in C1 so the result indicates if B1 exists anywhere in column A? |
|
#2
|
|||
|
|||
|
=isnumber(match(b1,a:a,0))
is one. Spottie wrote: If column A and column B both contain a list of names, what formula con I put in C1 so the result indicates if B1 exists anywhere in column A? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel quits responding searching for files not in my documents | Excel Discussion (Misc queries) | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
