Forum Discussion
Return multiple column headers based on row match and values between two numbers
I have been looking for days and can find similar examples but nothing that pinpoints why I cannot write this formula. I have data on 'Mileage!', on sheet 1 I have a dashboard with a dropdown in cel...
Since I do not know what version of Excel you are using, I have no way of knowing whether this solution is appropriate.
= LET(
miles, XLOOKUP(Site, Table1[[Site ]], mileage),
Array, CHOOSE({1;2;3}, tech, "", miles),
Nearby, FILTER(Array, miles<=50, "None"),
TRANSPOSE(Nearby) )