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?