| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does a value exist in another workbook
I have a column of Text terms in column A in one work sheet and want to see
if the terms exist anywhere in a separate work book and show Y in D if it does. ie does term " 0df " in A1 exist in workbook X if yes then past Y in D1, loop through to A27000 exist in wookbook X then past Y in D27,000. any ideas ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - Does value exist in range of CLOSED workbook? | Excel Worksheet Functions | |||
| Question relating to Named Ranges which exist in another workbook. | Excel Discussion (Misc queries) | |||
| Exist or Not. | Excel Discussion (Misc queries) | |||
| Am I Looking For Something That Doesn't Exist? | Excel Discussion (Misc queries) | |||
| Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
Threaded Mode
