On Oct 30, 7:59 pm, "Max" wrote:
One way, illustrated in this quick sample:http://www.flypicture.com/download/NDgxNzQ=
Sales rep pricing.xls

In the rep's sheet,

Assume the rep's "price" will be input in B1, eg: Price A
with the descriptions listed in A3 down, eg: Book1, Book2, etc

Put in B3, copy down:
=OFFSET(Prices!$A$1,MATCH($A3,Prices!$A:$A,0)-1,MATCH(B$1,Prices!$1:$1,0)-1*)
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
"Esradekan" wrote



I think i have written this wrong or something, coz thats not what i
want.
Let me try to simplify.
On 'prices' sheet, i have the following:(B2:G260)
Price A Price B Price C Price D etc
1 Book1 11.20 11.45 11.70 11.95
2 Book2 12.50 12.75 12.90 13.10
3 Book3 9.95 10.25 11.25 12.25
4 Book4
5 Book5
6 Book6
7 Book7
8 Book8
9 Book9 etc

Each Rep sheet
John Brown Price: Price A

Description Price
A1 A2

I enter the description (A1), and it gives the price in A2.

Does that make sense?

Hope so,
Esra- Hide quoted text -

- Show quoted text -

Genius, this works fine, thank you so much.
And thanks to all those who helped.

Esra