Need help with excel function formula

Hi guys, really need your help,

Lets say i have a text in a cell from
The text that i have is

A1,A2,A3,A4
B1,B2,B3,B4,B5,B6,B7,B8,B9,B10
C1,C2,C3,C4,C5,C6,C7
D1,D2
(these are all text's not the cell number)


is there anyway i can use a formula like 'if ' or vlookup that helps me
when the text is from A1 to A4, then "A" will come out on another cell, if B1 to B10, then come out B, if C1 to C7, come out C, if D1 to D2 then come out D.

example, if cell D6 contains text "A1", then it will come out , on another cell.
and if cell D6 contains text "D2" it will comeout D on another cell.

i keep trying to figure out using the if function, but I can't think of the formula.
Any help would be really greatly appreciated.

nstoner, welcome to the forum

however, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it is of interest to them, or falls within their area of expertese, they might only open those threads. also, searching for "help" will not turn up too many results that will benifit you, sorry.
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"