How can I use a Lookup or Query function for the following inGoogle Sheets:
I want to lookup the value in column A that coincides with theMax value in column B, taking into accout:
- I must calculate max in the function
- Column from where i want it to return is on the left of lookupcolumn
- I can't select the values as a table cause there are rows inbetween
How Can I Use A Lookup Or Query Function For The Following In Google Sheets I Want To Lookup The Value In Column A That 1 (17.08 KiB) Viewed 61 times
1 2 3 4 5 6 A Client A A Client B B Client C C B 1 2 3
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!