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
Posted: Sun Jul 10, 2022 11:26 am
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
1 2 3 4 5 6 A Client A A Client B B Client C C B 1 2 3
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 63 times