hello all,
I have a table of info, I want to select a number from a drop down list and have the maximum time from a range show on the next cell.
my original formula didn't work. I've been out of this game for a while and it's showing.
=XLOOKUP(B2,'Data '!A2:A12,MAX('Data '!B2:E2),"oops",0,)
I have 2 sheets in one workbook.
Data and Set up.
I want to be able to select the UNIT from a drop down list and have it display the max value of the next 4 rows.
help?
I have a table of info, I want to select a number from a drop down list and have the maximum time from a range show on the next cell.
my original formula didn't work. I've been out of this game for a while and it's showing.
=XLOOKUP(B2,'Data '!A2:A12,MAX('Data '!B2:E2),"oops",0,)
I have 2 sheets in one workbook.
Data and Set up.
I want to be able to select the UNIT from a drop down list and have it display the max value of the next 4 rows.
help?