Thank you so much,brianaclark1967
...struggling because mixed texts and numbers!
E4,
=VLOOKUP(D4&"",G4:H25,2,0)
Regards
Bosco
Can you please explain why you use D4&""? It is definitely correct, as D4 by itself did not work for me, but I cannot understand why..E4,
=VLOOKUP(D4&"",G4:H25,2,0)
Regards
Bosco
Hi Bosco,
Thank you for your help, but i think the mixed text/numbers caused an issue
Much appreciated.
Regards,
Brian
=VLOOKUP(D4&"",G3:H25,2,0)Can you please explain why you use D4&""? It is definitely correct, as D4 by itself did not work for me, but I cannot understand why..