Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas for transferring data validation information in excel 200
Hey,
I have a table list with part size callout in a column and material callout in a row on sheet 1 with pricing in the table. What I want to do is on sheet 2 use data validation to pick the part size in a cell and material in a cell then in another cell have it show me the corresponding price. I can send the file if it will help explain. I'm sure its some type of lookup formula but do not know. Any help is appreciated. Thanks, Tony |
#2
|
|||
|
|||
Hi
use VLOOKUP for this. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "Tony" schrieb im Newsbeitrag ... Hey, I have a table list with part size callout in a column and material callout in a row on sheet 1 with pricing in the table. What I want to do is on sheet 2 use data validation to pick the part size in a cell and material in a cell then in another cell have it show me the corresponding price. I can send the file if it will help explain. I'm sure its some type of lookup formula but do not know. Any help is appreciated. Thanks, Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |