Auto Fill Columns B, C, D based on Column data of A. Master List in a 2nd Sheet

You probably need to look into Vlookup()

With MPC4000 in cell A1 on Sheet2, use in B1 for Description

=vlookup(A1,Sheet1!A1:C100,2,false)

and in C1 for price

=vlookup(A1,Sheet1!A1:C100,3,false)

if that does not help....

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Just to take that a step further, if you want to "pre-populate" the formula down the sheet, you could use:

use in B1 for Description

=If($A1="","",vlookup($A1,Sheet1!$A$1:$C$100,2,false))

and in C1 for price

=If($A1="","",vlookup($A1,Sheet1!$A$1:$C$100,3,false))

Select the two cells with formulae and "drag" down as far as you need to go.

Regards

I'd start out with something like this for the basic mechanics of the input and lookup.

The Input Sheet could be be modified to include the Customer's name and Invoice/Delivery Address details, etc.

I've added Named Ranges for the PartNumber for the Data Validation drop down and PriceList for the VLOOKUP.


Regards

@mahju fyi
=IF(ISNA(C13),TRUE,FALSE)
In cf is not necessary just
=ISNA(C13)
will do