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.
Bookmarks