G
Guest
=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?
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?