| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup specific character place
I need to Identify the 10th character of F2 and return the correct year in
cell B2. For example: F2 VIN# JM1HD4616N0112078 - THE "N" identifies the model year 1992. I need to recognize the10th digit and place "1992" in the "year" field. I had trouble with wildcards in the "IF" function, any help would be great! A B C D E F 1 Stock # Year Description Color Miles VIN # 2 HT58904B MAZDA 929 BLK 36725 JM1HD4616N0112078 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert an 8 character Hex word to binary for a lookup? | Excel Worksheet Functions | |||
| lookup second character | Excel Worksheet Functions | |||
| Lookup Function - Specific Values | Excel Worksheet Functions | |||
| How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
| HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) | |||
Threaded Mode
