| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a criteria to an Index and Match formula
=INDEX(Sheet1!$A$1:$B$44,MATCH(I11,Sheet1!$A$1:$A$ 44,0),2)
How can I tell this to pull from column 2 or 3 dependent on criteria it matches in two different lists? say I have two lists of technician numbers and this is made to pull a dollar amount that matches a code. I need it to pull one dollar amount for one list and a different dollar amount for the second list. How come no one is answering this post? This is the second time i've posted this and no response. The first time I posted it to Excel programming. Am I not explaining it well enough? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup? Index? match? formula | Excel Discussion (Misc queries) | |||
| Index and Match Array formula | Excel Worksheet Functions | |||
| Index and Match - the next step | Excel Worksheet Functions | |||
| index match formula | Excel Worksheet Functions | |||
| How to add in an array formula if iisna index match | Excel Worksheet Functions | |||
Threaded Mode
