VLOOKUP Function for multiple tabs

[nayseem]

Good morning,

I have the logic but not sure how to code/go about creating a code.

I have an excel spreadsheet with 6+ tabs that I am using to keep track of approved time off for my staff.

I want a formula that will:

• Look for a person's name in column A and add the values that are associated in that corresponding row
• Look and add at all the tabs with the same logic as above

I have thought of everything to my knowledge and tried reading a few forums but no luck. (SUMPRODUCT, COUNTIF, INDIRECT, SUMIF, VLOOKUP)

Any suggestions?

Thanks in advance for your help!

 

[DRSteele]

If you could take the time to provide for us some sample data together with desired result, we could visualise your issue.

Look in my signature below for a link to an HTML Add-in.

 

[Aladin Akyurek]

1. Create a range housing the names of those 6 tabs you have.

2. Select the range in (1) and name it SheetList thru the Name Box on the Formula Bar.

3.

Let A2 house a person's name.

Now invoke in B2:

=SUMPRODUCT(SUMIFS(INDIRECT("'"&SheetList&"!B:B"),INDIRECT("'"&SheetList&"!A:A"),$A2))

This sums numbers from column B which correspond to the occurrences of A2 in column A.