Assuming source table as posted is in sheet: X
within A1:D100 (say), data from row2 down
Col A = brand, B = Prouct Name, C = Motorcycle Name, D = Unit Price

In your invoice sheet,
this table below is in cols A to D,
with "Price" to be computed in col E (= Qty x Unit Price from X)

Quantity Brand Product Name MotorCycle Name Price
10 KGW Head Lamp Supra ?
.....
(data from row2 down)

Put in the formula bar for E2, then array-enter the formula
by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER):
=INDEX(X!$D$2:$D$10,MATCH(1,(X!$A$2:$A$10=B2)*(X!$ B$2:$B$10=C2)*(X!$C$2:$C$10=D2),0))*A2

Adapt the ranges to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hero_honda" wrote:

Hello to you guys. I want to know if u guys can help me solve it.. this
isnt going to be easy guys.. but if u guys know a formula.. please help
me

A B C D
Brand Product Name MotorCycle Name Price
FMS Head Lamp Supra $15
FMS Head Lamp Tornado $25
FMS Exhaust Pipe Supra $80
FMS Exhaust Pipe Tornado $120
KGW Head Lamp Supra $40
KGW Head Lamp Tornado $50
KGW Exhaust Pipe Supra $150
KGW Exhaust Pipe Tornado $180

Here are some of my examples from my Price list. Im trying to use a
simple invoice with vlookup to bill my customer... lets say my customer
order

Quantity Brand Product Name MotorCycle Name Price
10 KGW Head Lamp Supra ?

The price if we look at it manually its $40 But how to use a formula
which it auto calculate the price for me? its not easy... i think we
need to use vlookup and if formula? Please help me!!


--
Hero_honda
------------------------------------------------------------------------
Hero_honda's Profile: http://www.excelforum.com/member.php...o&userid=34713
View this thread: http://www.excelforum.com/showthread...hreadid=544797