VLookup confusing
 

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.

VLookup confusing
 

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

"jag53" wrote:

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.

VLookup confusing
 

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

"Toppers" wrote:

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

"jag53" wrote:

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.

VLookup confusing
 

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

my typo ... sorry!

"jag53" wrote:

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

"Toppers" wrote:

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

"jag53" wrote:

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.

VLookup confusing
 

Thank you thank you thank you!!! God bless your brain:) That worked great.
Have a good day

"Toppers" wrote:

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

my typo ... sorry!

"jag53" wrote:

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

"Toppers" wrote:

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

"jag53" wrote:

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.