| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find data in one table from another.
I am reposting this to see if I can get another answer.
I need a formula that will allow me to search a column (B1:B19989) that contains text with the data from a column (A1:A32417) that contains a list of part numbers and display a result(True/False) into another column (C). Column B's text has the part numbers mixed in with the text. I need to know which numbers from column A are found within the text of column B. This is what I have tried in C1: =VLOOKUP(A1,CATALOG,2) All I get is #N/A - I know that the value in A1 exists in CATALOG CATALOG=The name of array B1:B19989 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| 1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
Threaded Mode
