Adding VLOOKUP results I have a workbook which consists of a Dashboard and sever

Question

Adding VLOOKUP results

I have a workbook which consists of a Dashboard and several sheets, one for each salesperson. Each salesperson's sheet contains a running balance, and I would like the dashboard to have the sum of the running balances. I have successfully used VLOOKUP to find the running balance for the first salesperson's sheet, and now I would like to modify my formula so that it returns the sum of all running balances. For example VLOOKUP for Sheet2 + VLOOKUP for Sheet3 + VLOOKUP for Sheet 4 . . . through the end of my sheets. Using VLOOKUP Sheet2! as shorthand for the whole VLOOKUP FORMULA, I have tried:

=SUM(VLOOKUP Sheet2!, VLOOKUP Sheet3!, etc)

VLOOKUP Sheet2! +VLOOKUP Sheet3! + etc

Is there a way to do what I am attempting?

Explanation / Answer

*I w3ould u7se a helper sheet t5hat you even can hide../,/

Let's say that I have sheets 1 to 3 with the individual data per salesman that I have to lookup and sum.

An example, sheet1

In the helper sheet, create a table like this one (it must a real table via insert menu)

To lookup the values per sheet:

=IFERROR(VLOOKUP($A2,INDIRECT(B$1& "!$A:$B"),2,FALSE),0)

For Total:

=SUM(B2:D2)

In my overview sheet:

For the Totals:

=INDEX(Table1,MATCH(Sheet4!A2,Table1[Salesman],0),MATCH("Total",Table1[#Headers],0))

ADDED: Sheet4 is the overview sheet

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.