Excel Formula Help

Hi

I have a complex question regarding formula. I hope this makes sense! :)

For my work, I have created a spreadsheet to log any invoices that I send to clients. We have numerous projects on at the same time. We also have a budget for each project. These projects last for months so we send our clients an invoice each month with the work we have done for the previous month.

What I have is an excel doc with two tabs: Invoices and Budgets.

I am able to filter my invoices by project to see how much I have invoiced for the life of the project. Eg, I have sent out 3 invoices for Project 1 (PR1)totalling $7000.

What I now want to be able to see is: When I filter by project, I want the Budget amount (for PR1 it is $10,000 - listed in the budgets tab) to appear in a cell in the invoicing tab so that I can see what I have invoiced against the Budget amount.

I have attached an example for you. I am trying to figure out the formula for the yellow cell.

Thanks in advance!

Nick's picture

vlookup

if you have a unique key, you can use the VLOOKUP function to grab a value from one place to the next.

try this tip:

13. Excel Tips - VLOOKUP