Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a sheet I am trying to make work and need some help figuring out a
function that will do what I want. On the first tab of my worksheet I have an "Invoice" set up that is looking for data from other tabs. Each of the other tabs has the same sets of information in short columns (about 10 rows each)-- one column for each month of the year where I imput the info i'm keeping. Each tab has a unique group name. What I would like to have happen is when I enter the the tab or "group" name in one cell on the first tab and then in another cell the month I am looking for, it will post that month's data from the column it's in on that sheet to the "invoice" sheet. I get a little lost in some of these more advanced lookup functions and was hoping someone out there might have an answer for me. Thanks! -- Steven Leuck Builders Electric, Inc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
If function using a list of criteria | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Function that gives Group level? | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |