FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA

[Guest]

Hi everybody,

Hey I am stuck up with this one. Can somebody help please.

I need to find a value of one cell from another sheet and paste that value
using automation (formula).

It would be a big task if one were to use the Find and replace comand
manually.

Thanks and regards


gkb

 

[Guest]

Hi AlieSlavin,

Thank you for your effort.

I think I did not explain my problem properly.

Example:

Sheet1
A B C D
E F
(Description) (value) (Description) (Value) (Description)
(Value)
1 1000H 122.22 1100P 150.00 3333T 100.00
2 1100H 133.33 1200P 160.00 4444T 200.00
3 1200H 144.44 1300P 170.00 5555T 555.00
4 1300H 155.55 1400P 180.00 6600T 600.00
5 1400H 178.88 1500P 190.00 7000T 100.00
6 1500H 198.00 1600P 200.00 8000T 200.00
7 1600H 123.00 1700P 122.22 9000T 300.00
8 1700H 111.00 1800P 144.44 1000T 444.00

Sheet2
A B C D E
F
(Description) (value) (Description) (value) (Description) (value)
1 1600H 1400P 1000T
2 1700H 1800P 1000T
3 1100H 1300P 8000T
4 1000H 1500P 9000T
5 1700H 1800P 1111T

Now I need to find the value of A,C & E and paste in columns B,D & F in
Sheet2 from Sheet1. Please note that Sheet 1 comprises of large data and only
small part of these data are required in Sheet2.

In rare cases, "Description" is not found in Sheet 1 and hence the
corresponding result for that particualar cell should be displayed "Not
found".

Hope I have explained properly this time.

Regards
gkb

 

[Otaibi2]

Hi,
lookup will do what you need

Regards
Waseem

Hi AlieSlavin,

Thank you for your effort.

I think I did not explain my problem properly.

Example:

Sheet1
A B C D
E F
(Description) (value) (Description) (Value) (Description)
(Value)
1 1000H 122.22 1100P 150.00 3333T 100.00
2 1100H 133.33 1200P 160.00 4444T 200.00
3 1200H 144.44 1300P 170.00 5555T 555.00
4 1300H 155.55 1400P 180.00 6600T 600.00
5 1400H 178.88 1500P 190.00 7000T 100.00
6 1500H 198.00 1600P 200.00 8000T 200.00
7 1600H 123.00 1700P 122.22 9000T 300.00
8 1700H 111.00 1800P 144.44 1000T 444.00

Sheet2
A B C D E
F
(Description) (value) (Description) (value) (Description) (value)
1 1600H 1400P 1000T
2 1700H 1800P 1000T
3 1100H 1300P 8000T
4 1000H 1500P 9000T
5 1700H 1800P 1111T

Now I need to find the value of A,C & E and paste in columns B,D & F in
Sheet2 from Sheet1. Please note that Sheet 1 comprises of large data and only
small part of these data are required in Sheet2.

In rare cases, "Description" is not found in Sheet 1 and hence the
corresponding result for that particualar cell should be displayed "Not
found".

Hope I have explained properly this time.

Regards
gkb