Index Formula help.

[serge]

Hi everyone,

I have this formula : =INDEX(G25:P25,1,C25)

But when C25 is a 0 the formula return : #VALUE!

What need to be added for the formula to work ?

Thank you. Serge.

 

[Andrew Poulsom]

Why do you need a second argument?

 

[serge]

Hi Andrew,

It's just that I have some data in G:P that need to be put in column R, but when in column C I hit a 0 the return in column R is : #VALUE! and should be which ever number it suppose to be from G:P.

 

[Andrew Poulsom]

Is this what you want?

=IF(C25,INDEX(G25:P25,1,C25),"")

 

[serge]

Thank you Andrew, for the formula but it doesn't work for me it returned a blank cell !!!

 

[serge]

Thank you again for your help Andrew but I found the answer.

The formula that I needed is : =INDEX(G25:P25,1,IF(C25=0,10,C25))

Regards... Serge.