I have to admit i may have made this complicated but i honestly do not see my error.
I have a Cell Validation that selects an name on sheet TEST1 "F6". Works FIne i get the list of names from sheet TEST2 column "F".
The formula in Cell validation "F6" is =OFFSET(test2!$F$2,0,0,COUNTA(test2!$F$1:$AF$10)).
My desire is to get The numerical value using =VLOOKUP(F6,test2!A2:F10,1,0) looking in test2.
I have and 2 examples and the AS IS works by Cell Validation and looking for the numerical value and adding name but i now have a need to work project in opposite fashion.
Always appreciative for help
Billyrj