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