if a cell contains codes listed i a column it will show its equivalent description

i'd like to have a formula

what if in Column B i'd enter a product code listed in other worksheet its equivalent PRODUCT DESCRIPTION in Column C (which is listed adjacent to the product list in the other worksheet), its price in Column G-I, then in Column D-F I will input the desired quantity, in Column F will compute the product of Column G-I and Column D-F,

really need help with this,

Thanks
Miskulet

Welcome to the forum kabayan.

First in your table get rid of the spaces before the Product codes. you can issue a formula like this in any cell
=TRIM(A3)

then you can use the index/match function
to extract the description

=INDEX('LIST OF PRODUCTS'!$B$3:$B$24,MATCH(Sheet1!B8,'LIST OF PRODUCTS'!$A$3:$A$24,0))
you can follow the formula above for the rest of the table (Price and Case)
the formula above means
=index(therangeyouwanttoreturn,match(lookupvalue,rangewheretolook,zeromeansexactmatch))

look at attachment

Copy of DELIVERY ORDER FORMAT.xls

do you want to get rid of the N/A errors?
you can do that with

=iferror(theformulaindex/match ,"") -if there is error put null/blank ..you can change the "" with 0 if you prefer

and with the total--include the iferror in the computation

=IFERROR((D9*G9)+(H9*E9)+(I9*F9),"")




now if you want the N/A error to appear and still compute for the total
you can use the sumif function
assuming N/A errors are displayed.
total sales order formula
=SUMIF(J9:J25,"<>#N/A")

Walang anuman kabayan.
Regards,
Vladimir

Some tips:

You can mark your thread solved
How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.