| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX / MATCH problem
Sheet 1 has 3 columns: grade, step, NBS
Sheet 2 has 3 columns: SM, grade, step I want to add a column NBS to sheet 2 for that exact grade and step, from the data on sheet 1. I tried the following formula but it gives me #value!. =INDEX(sheet1!$C$2:$C$6,MATCH(B2&C2,sheet1!$A$2:$A $6&sheet1!$B$2:$B$6,0),3) Thanks for your help Deborah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX and MATCH in one formula... | Excel Worksheet Functions | |||
| Index Match Help | Excel Worksheet Functions | |||
| Lookup nearest value (Index & Match) | Excel Worksheet Functions | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
| Complex LookUp / Match Problem ?? | Excel Worksheet Functions | |||
Threaded Mode
