Client Price Listing

[sjacobonef]

Hi, Im a first timer on forum so will try to be clear.

I have a sheet with products (columnA) and prices of 4 levels (column B, C, D, E). Each combination of cell beeing a price.
Then I have colum F, G H, to ... beeing each a client name. In each of these column I have already a letter "a" or "b" corresponding to the heading of column B,C,D,E (basically telling client xyz is on level a,b,c or d)
note, one client always have different levels of pricing depending on which product line

Is there a formula that can automatically pull out each product price for each client according to their level of pricing by product?

see here below an example but it looks like the forum window is compressing everything. Also a example file attachement (the yellow partbeeing what the results should look like... )

(A1 cell) list a list b list c list d client a client b client c client a client b client c
product a $1.00 $10.00 $21.00 $31.00 a b c $1.00 $10.00 $21.00
product b $2.00 $11.00 $22.00 $32.00 a b c $2.00 $11.00 $22.00
product c $3.00 $12.00 $23.00 $33.00 a b d $3.00 $12.00 $33.00
product d $4.00 $13.00 $24.00 $34.00 a b d $4.00 $13.00 $34.00

THANKS A BILLION FOR ANY SUGGESTIONS
Seb

[mrice]

Try pasting the following formula into Cell I2 and copying across and down.

=OFFSET($A2,0,MATCH("List " & F2,$B$1:$E$1,0))