Adding two index equasions into 1 cell

[jislandhopper]

Hi All,

I have two equations using index and work well individually. But as soon as I try to marry them both into 1 cell it fails.

The two equations are:

=IF(VLOOKUP(E83,podata,14,FALSE)=1,INDEX('[Operational Schedule (003).xlsb]Day Visit'!$B$2:$B$5000,MATCH(A83,'[Operational Schedule (003).xlsb]Day Visit'!$C$2:$C$5000,0)),"TBC")
The above looks at 1 index to return a value, if the IF statement is equal to . If higher it defers to the next Index equation.

=IF(VLOOKUP(E83,podata,14,FALSE)>1,INDEX('[Operational Schedule (003).xlsb]OCS'!$B$2:$B$5000,MATCH(A83,'[Operational Schedule (003).xlsb]OCS'!$C$2:$C$5000,0)),"Still got bugs")
Same concept as abovce but different array of data but working off the same method.

Together I thought it would work by trying the below with no luck :

=IF(VLOOKUP(E83,podata,14,FALSE)=1,INDEX('[Operational Schedule (003).xlsb]Day Visit'!$B$2:$B$5000,MATCH(A83,'[Operational Schedule (003).xlsb]Day Visit'!$C$2:$C$5000,0)),=IF(VLOOKUP(E83,podata,14,FALSE)>1,INDEX('[Operational Schedule (003).xlsb]OCS'!$B$2:$B$5000,MATCH(A83,'[Operational Schedule (003).xlsb]OCS'!$C$2:$C$5000,0)),""))

But this keeps saying the cell is 'false'
If you have any idea's or pointers it would be great as I've only used INDEX functions within simple returns before.

I can try to post the sheet but I think in reality it's the way i'm tyring to link the two formala's together.
Thanks
Jason

 

[Fluff]

You need to remove the = sign before the 2nd IF

 

[jislandhopper]

Thanks Fluff, that was an annoyingly simple I should have picked that up. Thats for your help.

 

[Fluff]

Glad to help & thanks for the feedback.