Amend formula to remove ‘FALSE’ if no valid data to display

Hi,

I’ve inherited a legacy workbook with the following formula :-

Please Login or Register  to view this content.

=IF(ISNUMBER($A5),INDIRECT("'PERFORMA Data'!L"&MATCH($A5,'PERFORMA Data'!$AV:$AV,0),TRUE))

Please Login or Register  to view this content.

The formula works fine when there is valid data in the corresponding cells on the 'PERFORMA Data' worksheet, however, when there is no data 'PERFORMA Data' worksheet in the corresponding cells it returns the text ‘FALSE’.

Can any please advise how to amend the formula to only display valid data (if available) and only a blank cell i.e. do not display the text ‘FALSE’ if no valid data


Many thanks I advance

Regards


Rob

=IF(ISNUMBER($A5),INDIRECT("'PERFORMA Data'!L"&MATCH($A5,'PERFORMA Data'!$AV:$AV,0),TRUE),"")

Special-K,

Excellent !!


Many Thanks


Regards


Rob