IF ISNA Vlookup problem (with 2 different Vlookups)

Hi,

Have been working on this formula and want to add another argument.

=IF(ISNA(VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE));"";((VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE))))

What I want to do is when the first formula failes and returns a blank I want it to perform another Vlookup in just the range

"VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE) ".
I tried to put it like this:

=IF(ISNA(VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE));((VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE))))

but then the values that was returned in the first scenario failes.

Any ideas ?

So you want if the first part fails, give answer to second part, else give answer to first part?

something like:

=IF(ISNA(VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE));VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE);VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE))