Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP NEED HELP Please
Hi,
I am in sales and created table1 to show how much income is coming from different categories(labor,products,etc). In other words I get paid 5 different ways and there will be 5 cells on each table2,table3,table4,etc that will have a sum and I want that sum to show in a specific cell on my table1 main page. MAIN TABLE: V7 will show total hours from table 2, table 3, etc added all together but the info pulled from each table thereafter. TABLE2 (WITH DATA THAT WAS INPUTTED) H46 shows total hours of projects. I would like this number which is on table 2 to show on table 1 (main). I will have more tables made as more sales I make, so 2 questions: -How do I pull data from specific cell on table 2 to show on table 1 specific cell. -What do I do once I have data on table3, table4, etc? Will a comma work or is there more to it? Thank you so much in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |