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?

Add a criteria to an Index and Match formula
 

It would be clearer with some sample data

Regards
--
AP

"Tomkat743" a écrit dans le message de
...
=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?

Add a criteria to an Index and Match formula
 

The first argument to INDEX should be replaced by an IF. I.e.:

=INDEX(IF(...,Sheet1!$B$1:$B$44,Sheet1!$C$1:$C$44) ,MATCH(I11,Sheet1!$A$1:$A$44,0),2)


Does this help?

Kostis Vezerides