Hi,
In my worksheet, i have formulae as follow:
IF(I$5="actual",IF(ISERROR(VLOOKUP($A17,'[worksheet1.xls]fun'!$A:$AO,I$3,FALSE)),0,VLOOKUP($A17,'[worksheet1.xls]fun'!$A:$AO,I$3,FALSE)),0)
FYI, I$3 is a blank cell.
As there are so many helpful experts on this forum, i would like to know is it possible to shorten this formula?
Thanks
Bookmarks