Probably something very silly! But I just can't work out why I'm getting a Ref error in B7?? - should be 1.72
Mdn
Probably something very silly! But I just can't work out why I'm getting a Ref error in B7?? - should be 1.72
Mdn
Remove B6 and use:
=INDEX(B3:W3,MATCH(B5,B2:W2,0)) or hardcoded:
=INDEX($B$3:$W$3,MATCH($B$5,$B$2:$W$2,0))
if you get rid of the column number it works fine.
from this... =INDEX(B3:W3,B6,3)
to this... =INDEX(B3:W3,B6)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
The syntax was incorrect:
=INDEX(B3:W3,B6)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Lovely stuff, really appreciated all
No probs!
You're welcome and thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks