complex formula

  • Thread starter Thread starter jleigh3
  • Start date Start date
J

jleigh3

Hi Frank,

I hope this helps. Thanx

Excel spreadsheet 1

A B C D E F



Excel spreadsheet 2

A B

97001 $20.30

97002 $15.40

97110 $23.60

97116 $22.22

97124 $25.65

97530 $34.45

97535 $33.33



Based on the item in Column D (spreadsheet 1) I need to
get the price from Column B (spreadsheet 2) and multiply
it by the units in Column F (spreadsheet 1)
 
Hi Joyce
enter the following formula in E2
=VLOOKUP(D2,'sheet2'!$A$1:$B$100,2,0)*F2
 
Back
Top