| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Partial match lookup question
=LOOKUP(10^99,MATCH("*"&Sheet2!$A$1:$A$10&"*",A1,0 )/(Sheet2!$A$1:$A$10<""),Sheet2!$B$1:$B$10) Perfect! Thank you so much... Would you mind explaining how it works? I understand the MATCH part, but what's the division for? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Lookup question | Excel Worksheet Functions | |||
| Partial String Match & Wild Cards Using VLOOKUP | Excel Worksheet Functions | |||
| can lookup return err if no match found | Excel Worksheet Functions | |||
| Partial String Match Using VLOOKUP | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
Hybrid Mode
