| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use 2nd digit from the left in cell contents for vlookup
Need to do a VLOOKUP and have it look for the 2nd digit from the left
in a cells contents, and find this value in a table,a and return a result. iow: If the cells contents are 2B75478A3, it would look for the "B" in the table; other variations would have the formula look for the 3rd character from the left or 7. Table would be B2:G20, column would be 4 TIA for thoughts. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Formulas to copy contents of one cell in a worksheet to another ce | Excel Discussion (Misc queries) | |||
| Selectively Clearing cell contents | Excel Worksheet Functions | |||
| Returning Cell Value if someone deletes the contents of a cell | Excel Worksheet Functions | |||
| How do I clear the contents of one cell from another cell? | Excel Worksheet Functions | |||
Threaded Mode
