VLookup confusing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been reviewing the VLookup function and set up but it is very
confusing to me so hopefully someone can help.

Sheet 1 - This will be the lookup sheet with range that can be edited if
more rows need to be added:
Code Description Price
111 stuff 13.00

On Sheet 2 I want to Enter the Code, find the code on sheet 1, and populate
the calculated Weight * Price and populate the Total field on Sheet 2
Sheet 2
Code Weight Total(the calculated field from lookup Sheet 1 price)
111 32164 (Price*Weight)

I figured out how to name the range on Sheet 1 so I called in Database.
I cannot get the formula right in Sheet 2 Total Column.
 
in Sheet2 , C2:

=B2*VLOOKUP(A2,Sheet1!$A$2:$A$100,3,0)

the 3 in the VLOOKUP returns the value in the 3rd column of your vlookup
table: in this case column C.

HTH
 
I messed up my explanation slightly. I need to enter the code and the
weight, in column 3 that will be the calculated price which should be the
result of the lookup table column 3. So, does this change slightly? I've
tried the info below but it didn/t work. I keep getting a circular error
 
Back
Top