Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Calculations
Not sure if a Vlookup is the right function but this is my situation: On one
worksheet i have a row of column headers and on the second worksheet i have the data. I want to compose a formula where I can lookup the column header from the first worksheet on the second and then if found, take the difference between two columns on the second spreadsheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Calculations
If you are wanting to do a vlookup using headers and the data is on a set
row, you want to look into the Hlookup function, a lot like vlookup but works horizontally. -- -John Please rate when your question is answered to help us and others know what is helpful. "RBG" wrote: Not sure if a Vlookup is the right function but this is my situation: On one worksheet i have a row of column headers and on the second worksheet i have the data. I want to compose a formula where I can lookup the column header from the first worksheet on the second and then if found, take the difference between two columns on the second spreadsheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Calculations
Maybe an illustration would better explain what I am trying to: I am trying
to lookup an item from worksheet 1 on worksheet 2 and if found i want to calculate the difference between gross and net without having to add an additional column on worksheet 2 for the difference. Thanks Worksheet 1 Computers Laptops Ipods Worksheet 2 Item Gross Net Computers 25 15 Laptops 10 5 Ipods 17 3 "John Bundy" wrote: If you are wanting to do a vlookup using headers and the data is on a set row, you want to look into the Hlookup function, a lot like vlookup but works horizontally. -- -John Please rate when your question is answered to help us and others know what is helpful. "RBG" wrote: Not sure if a Vlookup is the right function but this is my situation: On one worksheet i have a row of column headers and on the second worksheet i have the data. I want to compose a formula where I can lookup the column header from the first worksheet on the second and then if found, take the difference between two columns on the second spreadsheet. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Calculations
If as it seems you only have a single entry for computers etc in your second
sheet then this would work. =SUMPRODUCT((Sheet3!A1:A10="Computers")*(Sheet3!B1 :B10-Sheet3!C1:C10)) Mike "RBG" wrote: Maybe an illustration would better explain what I am trying to: I am trying to lookup an item from worksheet 1 on worksheet 2 and if found i want to calculate the difference between gross and net without having to add an additional column on worksheet 2 for the difference. Thanks Worksheet 1 Computers Laptops Ipods Worksheet 2 Item Gross Net Computers 25 15 Laptops 10 5 Ipods 17 3 "John Bundy" wrote: If you are wanting to do a vlookup using headers and the data is on a set row, you want to look into the Hlookup function, a lot like vlookup but works horizontally. -- -John Please rate when your question is answered to help us and others know what is helpful. "RBG" wrote: Not sure if a Vlookup is the right function but this is my situation: On one worksheet i have a row of column headers and on the second worksheet i have the data. I want to compose a formula where I can lookup the column header from the first worksheet on the second and then if found, take the difference between two columns on the second spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
N/A results on vlookup with time calculations | Excel Worksheet Functions | |||
Calculations | Excel Discussion (Misc queries) | |||
Calculations | Excel Discussion (Misc queries) | |||
how many calculations? | Excel Worksheet Functions | |||
Calculations | Setting up and Configuration of Excel |