Hi can anyone help?
I have numbers in A1:G102 and want to change the numbers to Letters using the reference in columns I1:K102,
I have give examples of the first three rows but would like a formula if possible to be able to drag down to the last rows to auto fill the rest,
I have uploaded an excel example,
any help would be apprieciated.
many thanks.
Re: Auto fill cells with Letter Value
In M1, type =vlookup(A1, $I$1:$K$26, 3, False) and copy down.
Re: Auto fill cells with Letter Value
Quote from AlanSidman;793514In M1, type =vlookup(A1, $I$1:$K$26, 3, False) and copy down.
Hi AlanSidman,
Thanks for your reply, I will give this a try.
Sorry about the duplicate post, didn't realise I had done that?
Regards
Re: Auto fill cells with Letter Value
This is how you want it
=SUMPRODUCT(I$1:I$26*ISNUMBER(SEARCH(K$1:K$26,M1:S1)))
Decio
Re: Auto fill cells with Letter Value
Thanks Decio,
I will give this a try
Regards
Don’t have an account yet? Register yourself now and be a part of our community!