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 ?
Bookmarks