Experts help needed
 

I have a table

Price 25 35 70 55 20 15 80

item Bell Cable Vac Security Ex Bell Ex Cable Ex Vac

Lot s* s* s* s* e* e* e*

101 2 3 1 1 1 1 1
102 2 3 1 1 2 3 1
103 2 3 1 1 1 2 2
104 2 3 1 1 3 5 1

s* - Standard, e* - Extra

Then I have another table

Lot Description Units Type Unit Price Total
Price

drop Drop down menu IF,OR ? IF,OR formula
down formula
menu

I need a way to to fill the Type (?) field with respect to the table,
which is standard or Extra depending on the item. And the Total price
is calculated based on if it is the standard item, it is the same
price as in Table 1, is it is Extra, it is the price on the Table 1
multiply that by the number of units.

Anyone know the solution, please email me at

Thnx
Prakash.....