Data Validation in cell

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Hi
I have a sales order form with the equipment on the second sheet as "PartNo"
"Description" "Cost" selected each column of data then clicked in the
cellname box and called them "PartNo" "Description" "Cost"
On the sales order form I have the columns "Qty" PartNo" "Description"
"Serial No" "QtyDes" "Price" Total"

I have set up data validation for the description as a list with
=Description what I want it to do is display the part no in the part number
Column and the cost in the price column. Also the list only shows the first
eight items with scroll bars is it possible to show more of the list I.e. 20
lines

Thanks in advance

Mark
 
You can use Index/Match formulas on the order form, to return the part
number and price. For example, with Description in column C:

=INDEX(PartNo,MATCH(C2,Description,0))

would return the Part number, and

=INDEX(Cost,MATCH(C2,Description,0))

would return the Price for the first order.

In the Data Validation dropdown, you can't change the default number (8)
of lines displayed.
 
Back
Top