| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difficulty with Search function that incorporates multiple workshe
need help urgent
Using 'Search' function with wildcard to find matching data in column of another worksheet eg search("mat*",'anotherExcel.xls'!Suppliers) formula does not recurse through column Is there a way i can overcome this or is there another formula or method I could apply Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difficulty with Search function that incorporates multiple workshe
Hi!
Try this: =SUMPRODUCT(--(ISNUMBER(SEARCH("mat",[anotherExcel.xls]Sheet1!$A$1:$A$10)))) A return 0 means there's a match. The best way to write these types of formulas is to open the other file and point to the references. Let Excel put the path in for you. Biff "gloss" wrote in message ... need help urgent Using 'Search' function with wildcard to find matching data in column of another worksheet eg search("mat*",'anotherExcel.xls'!Suppliers) formula does not recurse through column Is there a way i can overcome this or is there another formula or method I could apply Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you use multiple ranges in a function? | Excel Worksheet Functions | |||
| Using solver with function with multiple outputs | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Using functions to calculate multiple scores according to their level of difficulty | Excel Worksheet Functions | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
Hybrid Mode
