Hi
I'm trying to amend the following formula to include the ISBLANK function:
=IFERROR(INDEX('Extract (HireAssets-Sheet1)'!Q:Q,MATCH('Transform (Owned Assets)'!A:A,'Extract (HireAssets-Sheet1)'!C:C,0)),"")
The formula sits in a cell in the 'Transform (Owned Assets)' worksheet. The INDEX is returning a value from column Q of my 'Extract (HireAssets-Sheet1)' worksheet, if it's able to MATCH the value in column A in the 'Transform (Owned Assets)' with an entry in column C of the 'Extract (HireAssets-Sheet1)'. If it's unable to MATCH the value, instead of returning a #N/A, I'm using the IFERROR to return nothing ("").
I'm trying to work out how to incorporate the ISBLANK function into this. i.e. if the MATCH is able to find an entry, but there's nothing to return in column Q of the 'Extract (HireAssets-Sheet1)' worksheet, then instead of returning a 0 i'd again just like it to return nothing ("").
Hope that explains it well enough! Any help most appreciated!
Regards
Tom
Bookmarks