| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and left function
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
