| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How ger a value of the one sheet based in a text in other sheet.
I have two excel workbooks with different data, but a column with the same
information in them exists. As I obtain a value of one of books basing to me on the value thatexists in the common column? |
|
#2
|
|||
|
|||
|
It sounds like =vlookup() or =index(match()) would work ok.
Visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Carcastel wrote: I have two excel workbooks with different data, but a column with the same information in them exists. As I obtain a value of one of books basing to me on the value thatexists in the common column? -- Dave Peterson |
|
#3
|
|||
|
|||
|
It realy works
Many Tanks Dave "Carcastel" wrote: I have two excel workbooks with different data, but a column with the same information in them exists. As I obtain a value of one of books basing to me on the value thatexists in the common column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing an array based on text condition | Excel Discussion (Misc queries) | |||
| formatting based on text | Excel Discussion (Misc queries) | |||
| In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Format text based on which of several unique lists the value belongs to? | Excel Worksheet Functions | |||
Linear Mode
