Help in lookin up a value

Closed
sharifa6869 Posts 3 Registration date Monday August 11, 2014 Status Member Last seen August 13, 2014 - Aug 13, 2014 at 03:45 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Aug 13, 2014 at 03:33 PM
Hello,

I need help in getting a formula in excel

i have two sheets the fisrt sheet is the refrence sheet the second sheet is where i write my data

goin straight to the point

for example

sheet 1

column A |-----| column B

DH0083 |-------| 2G
DH0088 |------| 3G
DH0088 |-----| 2G
DH0089 |-------| 2G
DH0090 |-------| 2G
DH0091 |-------| 3G
DH0092 |-------| 2G
DH0088 |------| 2G
sheet2

column A |-------| column B |--------| column C
MU1051 |--------| 2G |----------------| 3G
MU1085 |--------|-----|----------------| ---
DH0088 |-------| 2G |---------------| 3G
DH0089 |--------| 2G |----------------| 3G
DH0090 |--------| 2G |----------------| ---



i want a formula that helps me to complete the data in column B & C in sheet 2 knowing that the refrence data in sheet 1 is combined in one column B as been seen above in the question but in sheet two i want to separate the 2G and 3G in two different columns B & C

hope you understood what am lookin for

thank you in advance











1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Aug 13, 2014 at 03:33 PM
sharifa6869, Good afternoon.

Take a look at the example I did for you.
http://speedy.sh/bYk6E/13-08-2014-enKioskea-Rearranging-Data-OK.xlsx

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0