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?