| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup a portion of a no. in a cell
Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg.
Table 1 Postal Code Area 200455 ? Table 2 Postal Code Area 20 A I want table 1 to reflect A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract portion of a cell | Excel Discussion (Misc queries) | |||
| Formula to multiply only a portion of a cell number? | Excel Worksheet Functions | |||
| A formula for moving a portion of a cell??? | Excel Discussion (Misc queries) | |||
| return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
| formaula used to abstract portion of a cell to another cell | Excel Worksheet Functions | |||
Threaded Mode
