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. |
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 |