Selected a cell depending on 2 factors

[Josh88]

Hi,

I have 2 elements that I would like to use to find the final result. I have quantity and length, upon which I am looking for price per unit. Here is a table of the information with quantity along the X axis and length down the Y:

	2500	5000	10,000	15,000
78m	0.76	0.73	0.71	0.70
90m	0.84	0.81	0.79	0.78
92m	0.85	0.82	0.81	0.80

<tbody>
</tbody>

I would like to have an automated calculation whereby I can build a basic info box containing the number of units required and their length, and the matching unit price is inserted.

Number of Units	5000
Length	90m
Price per unit	-???-

<tbody>
</tbody>

Thank you very much Excel wizards!

 

[jarjarbingie]

Hi,

I have 2 elements that I would like to use to find the final result. I have quantity and length, upon which I am looking for price per unit. Here is a table of the information with quantity along the X axis and length down the Y:

	2500	5000	10,000	15,000
78m	0.76	0.73	0.71	0.70
90m	0.84	0.81	0.79	0.78
92m	0.85	0.82	0.81	0.80

<tbody>
</tbody>

I would like to have an automated calculation whereby I can build a basic info box containing the number of units required and their length, and the matching unit price is inserted.

Number of Units	5000
Length	90m
Price per unit	-???-

<tbody>
</tbody>

Thank you very much Excel wizards!

=INDEX(Sheet1!$B$2:$E$4,MATCH(B2,Sheet1!$A$2:$A$4,0),MATCH(B1,Sheet1!$B$1:$E$1,0))

where the first table is in Sheet1

 

[Josh88]

Thanks,
So if both tables are in the same sheet, I can simply remove the Sheet1! ​?

 

[jarjarbingie]

Thanks,
So if both tables are in the same sheet, I can simply remove the Sheet1! ​?

yes, just change the references to the correct cells..