I am pretty sure that this is possible but can't quite figure out how to do
it and am not very literate in Excel. Here is my problem.

I am importing data using a web query and every time I update it the
information changes. For instance, this is what it looks like originally.

TEAM PRICE
Duke $144.81
USC $100.31

The order of the information in the web query changes depending on the
price. So if USC's price becomes greater than Duke's the next time I update
it would look like this:

TEAM PRICE
USC $147.88
Duke $144.81

This is where I run into my problem. The query uses columns A-G. I have
information that I put in in columns I-M that needs to stay attached to each
particular team. Example:

(QUERY INFO) (MY INFO)
TEAM PRICE WINS Games Played
Duke $144.81 6 8
USC $100.31 5 9

When the query updates and the information changes order, I need the other
information to change order with them so that the wins and games played stay
in the same row as the team they are supposed to be with.

Somebody mentioned using the VLOOKUP formula to somehow like them together
but from what I have been reading, to use that formula you have a unique
number or name in the first column but I don't have that with the information
that the web query pulls in.

Any help would be greatly appreciated.