A
Amnon Wilensky
Hi
I am trying to find a value in a table by using two parameters as shown in
the table below:
Diameter Height price
80 30 100
80 60 200
80 100 300
100 30 150
100 60 250
100 100 350
125 30 400
125 60 500
125 100 600
In A12 I want to input the diameter
In A13 the input the height
In A14 to have the result
Example:
A12=80
A13=100
A14 (the result) will give "300"
I tried to use Vlookup combine with Index and match without success.
Any help?
Thanks,
Amnon
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
I am trying to find a value in a table by using two parameters as shown in
the table below:
Diameter Height price
80 30 100
80 60 200
80 100 300
100 30 150
100 60 250
100 100 350
125 30 400
125 60 500
125 100 600
In A12 I want to input the diameter
In A13 the input the height
In A14 to have the result
Example:
A12=80
A13=100
A14 (the result) will give "300"
I tried to use Vlookup combine with Index and match without success.
Any help?
Thanks,
Amnon
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com