| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| Excel FIND ALL-How do you extract the findings to a new worksheet | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
