| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using INDEX & MATCH to VLOOKUP prior column
Hello!
I use range names for all my functions and I'm trying to lookup a number (LeadID) in a column (TechUserID) on another sheet (same workbook) and return the value one column to the left (TechFullName). I am using: =INDEX(TechFullName,MATCH(LeadID,TechUserID,0),1) But it is returning an "#N/A" The sort order of the sheet varies so I'm not sure if that has an impact in '07 like it did in previous versions, but I know it doesn't matter with VLOOKUP any more. Am I using the right function? -- --- TraciAnn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200905/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Match or Vlookup | Excel Worksheet Functions | |||
| Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
