Forum Discussion
help with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of e...
=FILTER('same file'!A2:E14,
IF(I2<>"",'same file'!C2:C14=Dashboard!I2,
IF(J2<>"",'same file'!B2:B14=Dashboard!J2)))
Maybe with FILTER function if you work with Office365 or 2021. If there is search criteria in cell I2 the data is filtered for a matching phone number otherwise for a matching name according to criteria in cell J2.