How do I nest more then 7 IF's?
"KenCanuck" wrote in message
...
HI Bob, essentially I have a row of 13 dollar figures, and my formula goes
like this... =if(k1=a1,a2,if(k1=b1,b2,if(k1=c1,c2,... Another way to do
that where I don't nest 13 IF's?? Thanks
Look at the HLookup formula. using the range A1..J2 it will find a value in
row 1 and return the value from the same col in row 2.
|