Excel Formula to copy paste value from one sheet to another.

[ryz306]

Dears,

I have 2 sheets in a workbook viz; Sheet1 and Sheet2, i need an excel formula to choose the price from Sheet2 when i input a code like 010001, 010900, 011500, 020100, 030200 etc in Sheet1 column "U"
There are at least 5000 cells in Sheet2 with price and the corresponding codes eg: Sheet2 - column A has codes as shown above, Column C has its related price, so whenever i put a code in Sheet1 Column U, the formula should search the price in Sheet2 and paste it in Sheet1 against the same code mentioned in Sheet1 in Column Y. Also the value that is copied and pasted in column Y should multiply first with the units in column "X" before displaying in column Y.


Thank you in advance,
Ryz.

 

[vletm]

ryz306
Hmm ... Copy Paste with formula ...
You could see values, but those won't be copy and paste.
You should upload a sample file
with sample values
with sample result
with clear idea.

 

[ryz306]

Please find sample of my workbook for your reference.
thanks

ryz

 

[vletm]

ryz306
Notes:
1) If You click cell [U1] or [X1] then ALL Prices will ReFresh
2) If You edit any SERV_CODE or UNIT then that rows PRICE will ReFresh
3) If You use SERV_CODES like 010001 then take care
that it is a text; also in Sheet2.
4) I didn't use 'formulas' because You would like to use 'copy paste'.

 

[ryz306]

Superb!!!

that is really working gr8,
Thanks vletm for your kind help, God Bless you.

Ryz