| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
| Confusing Problem | Excel Discussion (Misc queries) | |||
| Confusing VLOOKUP with Indirect reference | Excel Worksheet Functions | |||
| Confusing output from cells | Excel Discussion (Misc queries) | |||
| Drop Down Help Assistance is very confusing. Can someone help me. | Excel Discussion (Misc queries) | |||
Hybrid Mode
