CELL VALIDATION

[mark]

HI Thanks Debera
that sorted it
how do i stop the part no displaying #N/A in the part number and cost
without effecting the total coloum.
when the description is blank

Thanks

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.

 

[Debra Dalgleish]

In each formula, check for a value in the description column. For example:

For PartNo: =IF(C2="","",INDEX(PartNo,MATCH(C2,Description,0)))
For Price: =IF(C2="","",INDEX(Cost,MATCH(C2,Description,0)))
For Total: =IF(C2="","",A2*F2)