| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and left function
i assume the HAC4##### indicates there are multiple items of HAC4, the
easiest way would be to sort then just multiply them as they "sit". "Corey Osborn" wrote: I have 2 columns: Model qty HAC4##### 1 HHP4##### 2 HXA4##### 1 HXA2##### 3 HXH2##### 3 H9MPV#### 4 chair 1 toys 1 benchmark 1 HAC4, HHP4, HXA4, HXA2, HXH2, & H9MPV are the common identifiers that I am looking for. I would like to write an equations that looks for these common identifiers and muliplies 40 x the QTY column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup returns column to the left | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| Can Vlookup check a cell to the left? | Excel Worksheet Functions | |||
| Vlookup and Hlookup | Excel Worksheet Functions | |||
| VLookup ... Left side? | Excel Worksheet Functions | |||
Threaded Mode
