Forum Discussion
help with syntax/functions to select cells based on criteria of other cells
Hello, I need to find cells in different columns and rows that are associated with a maximum value. I got as far as using the UNIQUE and MAX/IF functions to get that maximum value, but I can't fi...
Adjust the back end of the range as needed.
Place in K2 and fill down.
=XLOOKUP(I2&J2,$A$2:$A$100&$B$2:$B$100,$D$2:$F$100)
Adjust the back end of the range as needed.
Place in K2 and fill down.
=XLOOKUP(I2&J2,$A$2:$A$100&$B$2:$B$100,$D$2:$F$100)
Thanks so much! This helps a lot and will save me a lot of time and headache!
- You're welcome. Have a great weekend!
