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?