| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search Sheet2! for the contents of Sheet1!
Hello, I have scratched my head far too long and need some help.
Sheet1! column A contains short names. Sheet2! column A contains full names. Here is what i would like to do. If the short name in Sheet1 cell A1 is found in any of the full names in Sheet2 column A then Sheet1 cell = 'yes' otherwise = null. Thanks, Wes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| build a search tool in excel | Excel Discussion (Misc queries) | |||
| Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
| Question regarding how to search a column and print a row(s) | Excel Worksheet Functions | |||
| Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Threaded Mode
