| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Right on the button. Thank you.
"JE McGimpsey" wrote: One way (array-entered): =MAX(IF(ISNUMBER(SEARCH("Lookup",$H$3:$H$271)),$C$ 3:$C$271)) If you want the search to be case-sensitive, use FIND() instead of SEARCH(). In article , Steven wrote: I have the following array: {=MAX(IF($H$3:$H$271="Lookup",$C$3:$C$271))} where it returns the max value. Is there a way to use * to say if lookup is in the string then that is an item to test the max on also. I was trying {=MAX(IF($H$3:$H$271="*Lookup*",$C$3:$C$271))} but that does not work. Is there a solution? Thank you for your help. Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Using wild card characters in array formulas | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
