I had help earlier on find this spreadsheet and thought everything was working fine however I just found out that it is not.
The way my current spreadsheet is, I need help in having it return a blank cell if the result is 0.
Current formula is: =IF(V3="","",INDEX(SORT(FILTER($B$3:$U$1001,$D$3:$D$1001=V3),20,-1),1,1))
In some cases, the All Hits column equals zero and if that is the cas, then I want it to display a blank or something similar instead of the location. I apolgize with how I'm wording this and hope that you are understanding.
I'm using Office 365 version of Excel
Thank you in advance.
Bookmarks