BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 267
- Office Version
- 2016
- Platform
- Windows
hello I have this formula:
=IF(E6='Actual vs. Budget'!E7,'Actual vs. Budget'!C7,"TBC")
I want to change 'Actual vs. Budget'!E7 so it's not just one cell but a range E7:E70..... and 'Actual vs. Budget'!C7 is the corresponding result in column C7:C70
so it looks for an exact match of the text in E6 anywhere in E7:E70 (it will only appear once) and returns the result from column C
I think index match is the answer but can't get it to work without a ref error, unsure where I am going wrong
=INDEX('Actual vs. Budget'!C7:E70,MATCH(E6,'Actual vs. Budget'!E7:E70,0))
=IF(E6='Actual vs. Budget'!E7,'Actual vs. Budget'!C7,"TBC")
I want to change 'Actual vs. Budget'!E7 so it's not just one cell but a range E7:E70..... and 'Actual vs. Budget'!C7 is the corresponding result in column C7:C70
so it looks for an exact match of the text in E6 anywhere in E7:E70 (it will only appear once) and returns the result from column C
I think index match is the answer but can't get it to work without a ref error, unsure where I am going wrong
=INDEX('Actual vs. Budget'!C7:E70,MATCH(E6,'Actual vs. Budget'!E7:E70,0))