| 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. |
| 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) | |||
Threaded Mode
