| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using wildcard for vlookup?
I have a worksheet with a field I'll call function code (FC). I want to
populate a field in each row depending on what the FC is. Example, I want this new field to be 10 if the FC begins with "40", 20 if it begins with "412", 30 if it begins with "42" but not "423". Is this possible? Maybe with a vba routine? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wildcard in formula vlookup | Excel Discussion (Misc queries) | |||
| sum if wildcard | New Users to Excel | |||
| Wildcard vlookup perhaps? | Excel Discussion (Misc queries) | |||
| Vlookup with wildcard | Excel Discussion (Misc queries) | |||
| Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
Threaded Mode
