| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
allow search on ranges of values
Hi all
I like to create a formula that will do wildcard searches for each individual field of a worksheet for ex if i have a column with 10 row (E1:E10) and like to apply a similar formula for each (A1 = dar, A2 = case) search(A1*, 'anotherWorksheet.xls'!Column) search(A2*, 'anotherWorksheet.xls'!Column) how can i go about removing the wildcard errors |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Cells with certain date ranges as values | Excel Worksheet Functions | |||
| build a search tool in excel | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
| search list for values | Excel Worksheet Functions | |||
| search after values | Excel Discussion (Misc queries) | |||
Linear Mode
