Question

please create an hlookup formula for these two transactions for price per unit

N 3 Units Sold Price per Unit Sales Total Transaction No. Date of Sale 9/1/2019 9/2/2019 Item Name Tennis Racket Baseball $0 Tennis racket Baseball Football 8 Name 9 Cost per Unit 10 Price per Unit Golf club Baseball bat (driver) 35 100 60 150 Hockey stick 45 100 80 190 30 1

Answer 1

X for transaction no А в со E F Ι Η transaction no date of sale item name | units sold 09-01-2019 tennis racket 60 09-02-2019 baseball 70 price per unit 150 1 sales total $ 9,000 $ 1,050 15 name 9 cost per unit 10 price per unit tennis racket 60 150 baseball baseball bat golf club (driver) hockey stick football 61 35 L80 L 45 14 15 100 190 100 30 12

for formulas and calculations, refer to the image below -

A3 X for transaction no G H transaction no date of sale 43474 43505 item name units sold tennis racket 60 baseball 70 price per unit sales total =HLOOKUP(C4,$A$8:$G$10,3,FALSE) =D4*E4 =HLOOKUP(C5, $A$8:$G$10,3,FALSE) =D5*E5 golf club (driver) name tennis racket baseball 9 cost per unit 60 16 10 price per unit 150 15 baseball bat 35 8 1 00 1 0 90 hockey stick football 14 100 30

In case you have any query, kindly ask in comments.