If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Name Label to try to define linked cell
I have an excel work book downloaded daily. The workbook contains pricing.
On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
#2
|
|||
|
|||
Hi
have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
#3
|
|||
|
|||
The VLookup looks very useful for this
Would I do a Range_Lookup from my destination cell to search the source document for an exact value since it's position may change? "Frank Kabel" wrote: Hi have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
#4
|
|||
|
|||
Hi
yes you would. But the exact usage depends on what you want to return? -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... The VLookup looks very useful for this Would I do a Range_Lookup from my destination cell to search the source document for an exact value since it's position may change? "Frank Kabel" wrote: Hi have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
#5
|
|||
|
|||
Here is what I'm trying to do:
I have a table that I'll call the destination table. This contains a value of 5.25. I have given a name called Rate in two tables. I'm trying to get the value from my destination table, in this case 5.25 search the Rate Lookup for an exact match. Then I want to get the next cell over called 7 Day for both tables. I am then trying to get EXCEL to populate the higher of the two rates in position two of my desintation table? In short I'm trying to get a rate from each table, then goto the next lookup column called 7 day. Compare the two 7 day prices and give the result in the destination table. "Frank Kabel" wrote: Hi yes you would. But the exact usage depends on what you want to return? -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... The VLookup looks very useful for this Would I do a Range_Lookup from my destination cell to search the source document for an exact value since it's position may change? "Frank Kabel" wrote: Hi have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
#6
|
|||
|
|||
Hi
do you mean =MAX(VLOOKUP(5.25,range1,2,0),VLOOKUP(5.25,range2, 2,0)) Where range1 and range2 are your two ranges with rates -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... Here is what I'm trying to do: I have a table that I'll call the destination table. This contains a value of 5.25. I have given a name called Rate in two tables. I'm trying to get the value from my destination table, in this case 5.25 search the Rate Lookup for an exact match. Then I want to get the next cell over called 7 Day for both tables. I am then trying to get EXCEL to populate the higher of the two rates in position two of my desintation table? In short I'm trying to get a rate from each table, then goto the next lookup column called 7 day. Compare the two 7 day prices and give the result in the destination table. "Frank Kabel" wrote: Hi yes you would. But the exact usage depends on what you want to return? -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... The VLookup looks very useful for this Would I do a Range_Lookup from my destination cell to search the source document for an exact value since it's position may change? "Frank Kabel" wrote: Hi have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the destination workbook in such a way to adapt to the changes that might happen when the values move from one cell to another. For example product called product 2 sometimes moves to position three in the source workbook but its still alays called product 2. So is there a way to have the source document auto link to the label of the destination i.e. product 2? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell within table within label document fails | Paul Fry | Mailmerge | 0 | September 23rd, 2004 09:46 PM |
How do I define a true null in a cell in Excel 2002 | BTY | General Discussion | 2 | August 24th, 2004 11:28 PM |
using a decimal point changes cell to label | Adam | Worksheet Functions | 1 | February 28th, 2004 05:11 AM |
Change cell reference for a linked formula | Samantha | Worksheet Functions | 1 | November 23rd, 2003 01:55 PM |
Leave cell blank when linked to another workbook | Wesley Sparks | Worksheet Functions | 2 | October 4th, 2003 01:28 AM |