VLOOKUP mult. values and sum result?

[BradMichaels]

I have a question on the VLOOKUP function.

I have a spreadsheet that lists out clients with their account numbers and the revenue they earn (B2:D7). I have a data range (F2:G22) that lists revenue by account number. Some clients have multiple accounts and I'd like the vlookup result to show the sum of the revenue for the multiple accounts. If possible, how would I structure that formula?

 

[T. Valko]

I agree, but that's not going to happen although I'm making a case for it. The example I provided was just to explain what I'm trying to figure out how to do as I do multiple account summations manually today.

OK.

Just don't "kill" yourself when there are other options!

 

[Domenic]

Yes they both work.

What would I have to change if I switched my account number to a different length? Sorry, I don't fully understand the functions of the formula to figure it out myself.

If, for example, your account numbers are 8 digits in length, you'll need to replace...

*5-5+1

with

*9-9+1

As you can see, the number 5 changes to 9. That's 8 digits for the account number and one for the comma for a total of 9.

 

[BradMichaels]

If, for example, your account numbers are 8 digits in length, you'll need to replace...

*5-5+1

with

*9-9+1

As you can see, the number 5 changes to 9. That's 8 digits for the account number and one for the comma for a total of 9.

Awesome, thank you!

 

[Domenic]

You're welcome! Thanks for the feedback!