Hi all
I'm sure this is a pretty simple question but I cant seem to get my head round the answer.
I want to use VLOOKUP to search for values on various tabs in a workbook. I want the tab that is searched to be conditional on the contents of a cell on the summary tab. I have the following formula
=IF(BVA!O$13>0,SUMIF(BVA!$D:$D,'Spend v budget'!$B3,BVA!O:O),IF('CB May'!$J$4>0,SUMIF('CB May'!$H:$H,'Spend v budget'!$D3,'CB May'!$J:$J)-SUMIF('CB May'!$H:$H,'Spend v budget'!$D3,'CB May'!$I:$I),SUMIF('Cash forecast'!$B:$B,'Spend v budget'!$B3,'Cash forecast'!J:J)))
I want all references to 'CB May' to be whatever the contents of cell M1 are.
Can anyone help?
I'm sure this is a pretty simple question but I cant seem to get my head round the answer.
I want to use VLOOKUP to search for values on various tabs in a workbook. I want the tab that is searched to be conditional on the contents of a cell on the summary tab. I have the following formula
=IF(BVA!O$13>0,SUMIF(BVA!$D:$D,'Spend v budget'!$B3,BVA!O:O),IF('CB May'!$J$4>0,SUMIF('CB May'!$H:$H,'Spend v budget'!$D3,'CB May'!$J:$J)-SUMIF('CB May'!$H:$H,'Spend v budget'!$D3,'CB May'!$I:$I),SUMIF('Cash forecast'!$B:$B,'Spend v budget'!$B3,'Cash forecast'!J:J)))
I want all references to 'CB May' to be whatever the contents of cell M1 are.
Can anyone help?