handling linked internet data

**Bruce35dc** · 10-12-2011, 02:27 PM

I have a spread sheet that has 1 page (call it the import page) where we directly bring in from an internet link a list of item and prices. A second page in that spreadsheet references various prices and items from the first page.

Problem is, from time to time, we add a new object to the internet source of data. This results in a new row (or 2) added to the import page.

The result of which is all our formulas that referred to the data on the import page are no longer accurate, as the item that the formula was referring to has been "pushed down" to a lower row on the import page.

What is the most efficient way for us to structure this to avoid having to redo the links\formulas when the the import page changes?

**GeneralDisarray** · 10-12-2011, 02:34 PM

need example sheet if you can provide one

**JBeaucaire** · 10-12-2011, 02:38 PM

Your sheet2 should have non-changing references that can be used to "match" to the sheet1 variable placement of the same moving information. If one string being imported was "doodads, $4.50" then on sheet2 you would have a cell permanently designed to find "doodads". So put "doodads" in A2, then in B2 a "find" formula will always be able to find it on sheet1 and bring over the price:

=VLOOKUP(A2, Sheet1!$A:B, 2, 0)