Index Match not working when linked in name manger from a formula

[mingandmong]

Hi Im using excel 2010

In the name manager i have a range using this formula =INDEX('Picture Lookup'!$Z$2:$Z$3,MATCH('Picture Lookup'!$I$2,'Picture Lookup'!$Y$2:$Y$3,0))

its not working correctely im using another formula in $I$2 on my sheet to return the value of either a 0 or 1

If i type the 0 or 1 in cell $I$2 it works just fine, but not with the formula (=RIGHT(B2,1) which is returning the correct values of 0 or 1

Any ideas how to resolve

 

[Scott T]

Try

(=RIGHT(B2,1)+0

Your formula is returning text the +0 will turn it into a number.

 

[mingandmong]

Thank You Scott T

worked a treat