Searching Product Price from Price List

[Kamal Subhani]

Hi All

In Sheet 2 I have the price list as follows
Column A
Size(in A2) Quality1 (In B2) Quality2 (in C2) Quality3 (in D2) ....till J2
Product A 100 90 80
Product B 90 80 70
Product C 80 70 60
......... ... ... ...
......... ... ... ...
......... ... ... ...

till row 1000


in Sheet 1 i want a formula to retrieve a the product price to retrieved according to the Size and the quality as follows

A2= Size B2=Quality C2=Formula (which I need to copy down


Hope u have understood me problem


Thanks in advance.


Regards


kamal

 

[fairwinds]

Like This?

Book1.xls
	A	B	C	D	E	F	G	H	I	J
1	Size	Qual1	Qual2	Qual3	Qual4	Qual5	Qual6	Qual7	Qual8	Qual9
2	Prod1	200	190	180	170	160	150	140	130	120
3	Prod2	190	180	170	160	150	140	130	120	110
4	Prod3	180	170	160	150	140	130	120	110	100
5	Prod4	170	160	150	140	130	120	110	100	90
6	Prod5	160	150	140	130	120	110	100	90	80
7	Prod6	150	140	130	120	110	100	90	80	70
8	Prod7	140	130	120	110	100	90	80	70	60
9
10
11
12	Size	Qual
13	Prod5	Qual3	140
14
Sheet6

 

[Kamal Subhani]

What will happen if Copy the formula down.

will it work or I have to change


Plz tell me
Kamal

 

[fairwinds]

Change to absolute ref:

=INDEX($B$2:$J$8,MATCH(A13,$A$2:$A$8,0),MATCH(B13,$B$1:$J$1,0))

Then you can copy down.

 

[Kamal Subhani]

Thanx Fair winds


Can It be done by ant other approac
I mean to say without index match


Thanks


Kamal

 

[fairwinds]

Of course... What other factors are involved?