how can I make it possible for the formula below to return a blank instead of a zero if the cell it is searching does not contain any data?
{=IFERROR(INDEX(Deed!$P:$P,SMALL(IF(ISERROR(SEARCH(Tract!$A108,Deed!$AW:$AW)),FALSE,ROW(Deed!$AW:$AW)),COLUMNS($A108:$A108))),"")}
Hi,
The array formula appears to be searching across a whole range (column AW) yet your request mentions 'Cell' in the singular.
It would be useful to see your request in the context of its workbook since sometimes other and simpler methods suggest themselves. However one not very elegant way is to just repeat your formula in an IF test
i.e.
or an even simpler way is just to go to the Options Advanced and untick the parameter 'Show a zero in cells that hae a zero value' for the sheet in question.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I went with the Options - Advanced - untick 'Show a zero in cells that have a zero value' and it works like a charm. Thank you for your help Richard!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks