| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index/Matching in combination w/Right()
I have a spreadsheet worksheet used as lookup table where Col A2:A65 =
JCodes and Col B2:B65 = JDesc. Job Code is a general field with JCodes formatted as 004455, 000333, etc. (two leading 0s with each JCode). On another worksheet I enter the JCode to get the JDesc using the six character JCode (=INDEX(JobCodes!$B$2:$B$65,MATCH(A13,JobCodes!$A$ 2:$A$65,0)). I want to use just the last 4 characters to return the JDesc (maybe using the right() function). Anywho, I havent had much luck except to get error or value messages. Please help.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index match combination | Excel Worksheet Functions | |||
| Index / match combination | Excel Discussion (Misc queries) | |||
| Combination...SumProduct, Index, Match? | Excel Worksheet Functions | |||
| index and matching in userform! | Excel Discussion (Misc queries) | |||
| matching a combination of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
