Previous Topic Next Topic

Help in lookin up a value

Closed
sharifa6869 Posts 3 Registration date Monday 11 August 2014 Status Member Last seen 13 August 2014 - 13 Aug 2014 à 03:45
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Aug 2014 à 15:33
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











Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
13 Aug 2014 à 15:33
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