Extract Value from another worksheet
 

I have a work sheet that has parameters Mem1, Mem2 etc. I have another
Worksheet ehich has the values for these parameters e.g. Mem_rom_234g
for Mem 1 and so on.

I am looking for an excel macro that can take the value of mem from
another work sheet and replace it with the value.

Thank you,
Dhawal

Extract Value from another worksheet
 

There are several different ways
1:
If the answer is always in the same column and same row then:
=IF(sheet2!A1<"",sheet2!A1,"")
If the "Mem" appears in the sasme column, but varies in which row then
=VLOOKUP(aheet1!F1,Sheet2!A1:H33,5,FALSE)

HTH



"Dhawal" wrote:

I have a work sheet that has parameters Mem1, Mem2 etc. I have another
Worksheet ehich has the values for these parameters e.g. Mem_rom_234g
for Mem 1 and so on.

I am looking for an excel macro that can take the value of mem from
another work sheet and replace it with the value.

Thank you,
Dhawal