Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning a value from x and y coordinates
I have a table in my estimating template that has screw density on the x axis
and screw length on the y axis. and the price per 1000 square feet in the field. I want to be able to input the density and length in cells by themselves and have the price go to a 3rd cell, automatically calculating total cost. VLOOKUP and HLOOKUP don't work for both axis. Can I solve this with a formula? Any help here is appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning a value from x and y coordinates
Use a MATCH to find the position of your length and density, then the INDEX
function that locates an item in a table. Example, I have the length labels on A2:A8, then the density labels on B1:G1. The formula is: =INDEX(B2:G8, MATCH(<length,A2:A8,0), MATCH(<density,B1:G1,0)) AJB wrote: I have a table in my estimating template that has screw density on the x axis and screw length on the y axis. and the price per 1000 square feet in the field. I want to be able to input the density and length in cells by themselves and have the price go to a 3rd cell, automatically calculating total cost. VLOOKUP and HLOOKUP don't work for both axis. Can I solve this with a formula? Any help here is appreciated. Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200707/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
coordinates of a point | Charts and Charting in Excel | |||
Are These Coordinates? | Charts and Charting in Excel | |||
map coordinates | Charts and Charting in Excel | |||
geographic Coordinates | Excel Discussion (Misc queries) | |||
Triangular Coordinates | Charts and Charting in Excel |