I think I need to use SumIf with a Vlookup function but I'm just not sure.
I've attached a spreadsheet with 2 tabs.
I want to say, if Nov!A1 is found within Sept!$A$1:$A$10 then sum Nov!B1 - Sept!B1, otherwise, just display Nov!B1
How do I write this formula?
Thanks,
Steve
Bookmarks