Hello,

Thanks, but seems i am making errors, the cell is calculating wrong value.

Is it possible to give one example formula in the below case please.

thanks

gkb

" wrote:

Hi,
lookup will do what you need

Regards
Waseem

On Dec 7, 10:38 am, gkb wrote:
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



"AlieSlavin" wrote:
Easy, it would look something like:

='Sheet2'A1

That should put the value of cell A1 on Sheet2 into the cell you paste the
formula in. Does that help? Or do you need more than just that one cell
value?

"gkb" wrote:

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- Hide quoted text -- Show quoted text -