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!
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: