Vlookup calculating

[tomdelonge]

I have three v lookup functions in this book, can someone help me on how to calculate the total of these three lookups in the B Total box, thanks.

I have attached the book I am working on.

[NBVC]

Not sure exactly what you mean...there is a Vlookup in the box already...

What exactly do you want to see as a result?

[tomdelonge]

Sorry, I am really bad at explaining things and I am at work at the moment and I was being ushered off the pc.

I have B1 B2 and B3 as dropdown menus.

The B Total box is currently set to show the "£" of the B1 box. I am wanting it to show a total of B1, B2 and B3. So the user can select in those 3 B boxes what benefit they want and then the B Total box will show a total of those selected.

I.E

B1 = A benefit
B2 = A benefit
B3 = A benefit
B Total = The sum of B1, B2 and B3.

B Total will look for the numbers of all 3 then add them up.

I am not advanced in excel, I even had to get help from here about the Vlookup function.

The sheet is for advice workers who work at the community centre I am at. They currently use note books to keep records and they have to carry them around incase they see a client for a second time, they need the information from the first time. The current advice worker has 11 notebooks she has to carry around with her 'just incase' she needs them. It is far easier to carry say 1 spreadsheet with multiple worksheets on her tiny USB stick. Plus the edit>find function will help finding a clients record quickly.

I have tried to get all this to work in a database but it has been a fair few years since I did something so 'tricky' and the access forum I was using didn't really offer me much help as they had no idea whatsoever what I was trying to do and when I showed them the excel sheet it didn't help either.

[NBVC]

I think you would just sum the 3 Vlookups..

e.g.

Please Login or Register  to view this content.

[tomdelonge]

I think you would just sum the 3 Vlookups..

e.g.

Please Login or Register  to view this content.

THANK YOU!!
I have been googling this for the last 40 minutes with no sucess.
That is all I wanted to do.
Sorry for the long winded explanation.
As I have said before, I am not good at explaining quite what I want.

[NBVC]

From PM:

Hi you helped me with calculating multiple vlookups.
I now have an error.
In the first vlookup cell it says £0.00 if I dont have anything selected in the B1 etc cells.
But when I use the little square in the corner of the cell to drag the formula down, I get an #N/A displayed.
I need it so I can fill in just one of the cells with the dropdown menu's.

The formulas I have for the first one (I move some things about) is;

=VLOOKUP(E4,'Benefit Reference'!A:D,4,0)+VLOOKUP(F4,'Benefit Reference'!A:D,4,0)+VLOOKUP(G4,'Benefit Reference'!A:D,4,0)

In the cell beneath I have;

=VLOOKUP(E5,'Benefit Reference'!A:D,4,0)+VLOOKUP(F5,'Benefit Reference'!A:D,4,0)+VLOOKUP(G5,'Benefit Reference'!A:D,4,0)

Could you tell me why I am getting the #N/A please?

The #N/A occurs when you don't have all 3 selections made:

Try:

Please Login or Register  to view this content.