complex formula

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)
 
F

Frank Kabel

Hi Joyce
enter the following formula in E2
=VLOOKUP(D2,'sheet2'!$A$1:$B$100,2,0)*F2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Help with lots of formulas 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
lookup two different variables 0
Formula for looking up and copying from another worksheet? 1
Help! Is this possible 2
If Formula and Dates 4
Excel VBA macro, search - accumulate - delete original 0

Top