obscure header i know, but all i know how to describe it.

i have a worksheet that lists the products i sell.with different
pricing scales on it,,,it is in the form i guess of an array, and i
need to access it by having data (the correct data) put into a sheet.

Now, i have a sheet for each rep, it says on that sheet wether he will
be price1, price2, prioce 3, price 4, price5. It quotes that on cell
g2. I have all tghe products listed, B2:B260, with price 1, price 2
etc, along C1:G1, with corresponding prices in relevant cell.

How can i access the right data, if say i put book 1 in a cell on the
worksheet, and get the corresponding and correct price, in the next
cell, (assume the one containing the formula) for that product??, is
it Index/Match?, or VLookup, and what formula woudl i use?

TIA

Esra