Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup with two variable data list cells
I am attempting to create a simple quotation sheet
I have one cell in Sheet1 validated as list: C1 - Customer Price-band Category (select from list) and cells each refering to: A1:A100 - Part Numbers (select from list) In Sheet2, I have price lists for each Price-band Category against each Part Number. In the cell adjacent to the Part Number in Sheet1, I would like to display the relevant part price depending on which Price-band Category and which Part Number has been selected I would appreciate any thoughts... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions |