Extract Value from another worksheet

  • Thread starter Thread starter Dhawal
  • Start date Start date
D

Dhawal

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract Value from another worksheet 6
How can I extract hyperlink value 1
Excel Macro to Insert the contents of one column to other 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
sort by name when user selects name on another worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Auto Naming Worksheets 4

Back
Top