That's the one! Thanks!!!

"Bob Phillips" wrote:

=INDEX(A2:M2,,MATCH(Sheet1!K1,A1:M1,0))

--
__________________________________
HTH

Bob

"KenCanuck" wrote in message
...
Essentially I have a row of 13 dollar figures that I need to do a formula
that says =if(k1=a1,a2,if(k1=b1,b2,if(k1=c1,c2... Is there another way to
do
that?

"M Kan" wrote:

Are you trying to use this to catagorize a data set or summarize by
several
criteria? As far as I know, you can't nest more than 7 IF statements.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"KenCanuck" wrote:

I need to nest about 13 IF functions in one formula, can I do this?