Hi Is there any chance someone could help translate this into a Index Match for me please?
=VLOOKUP($F$6,$F$10:$NK$13,MATCH($D$6,$F$9:$NK$9,0),FALSE)
Also if its not too much bother I'm also after the same index match formula to return the data which is located in the next cell down from the original formula!
Thanks
=VLOOKUP($F$6,$F$10:$NK$13,MATCH($D$6,$F$9:$NK$9,0),FALSE)
Also if its not too much bother I'm also after the same index match formula to return the data which is located in the next cell down from the original formula!
Thanks