| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching numbers and text
I have on spreadsheet that has a column with a list of single numbers or
letters the next column are times associated with those numbers and letters. I want to type in one of those numbers or letters and have it displayed in another worksheet the time associted with it. I have it half working that is displays the letters but is comes up with a #N/A when you type in a number to match. Here is what I am using. Any help would be appreciated! =INDEX(Codes!$A$2:$B$33,MATCH('F Codes'!G7,Codes!$A$2:$A$33,FALSE),2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Checks, Matching and deleting numbers | Excel Discussion (Misc queries) | |||
| vlookup with not exactly matching numbers | Excel Discussion (Misc queries) | |||
| matching a combination of numbers | Excel Discussion (Misc queries) | |||
| matching numbers in col a and col b | Excel Worksheet Functions | |||
Threaded Mode
