Good Afternoon,
I have an Index against 2 matches, but i need to add an IF statement to it if a cell contains a number, here's the formula
=IF(T12="1",(INDEX(Extras!$A$1:$G$6,MATCH($AK$10,Extras!$A$1:$A$7,0),MATCH('Traffic Sheet'!$H12,Extras!$A$1:$H$1,0))))
i think that i have been trying to work it out for too long and can't see the obvious solution.
help me please,
thanks reg
Bookmarks