Forum Discussion

addori's avatar
addori
Copper Contributor
Jan 31, 2022

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...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 31, 2022

addori 

=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.

  • 2423's avatar
    2423
    Copper Contributor
    Dec 05, 2025

    You might get very familiar with tables. I find it to be a very valuable tool and suspect that many of the tables we use like tax tables only scratch the surface. I have experimented with tables much larger and calling up alpha like names is very successful. I created a large table that I use for tagging entries with very specific storage locations and dates. Of course now I am moving away from very helpful macros which are almost impossible to use in the current anti macro climate.

Resources