Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index



I have eight data values on a single row with corresponding dates next to each value in the format below i.e.

A       B       C       D       E       F       G       H
25      01/07   blank   60      09/05   blank   30      26/7

In the 2nd row I would like to show the highest number from the first row as well as the corresponding date value in the cell to the right of that value.

My A2 formula is MAX(A2,D2) = 60

The issue I am having is to get the corresponding date value from the adjacent column i.e. 09/05 in row B2.

The formula I have tried include:
=MATCH(INDEX(A2),A1:H1,0) = #N/A

I figured that as VLOOKUP looks for values below that HLOOKUP might be better suited. That said I have always battled understanding the terminology for the requirements for both vlookup and hlookup, even Index and Match needs understanding I don't have.

I read the LO manual online and Google has been some help but seems to always go the VLOOKUP route with all the data under each other. Unfortunately this sort of 'table' VLOOKUP requires is not feasible on my data set.

I should probably use BASE but have not delved into that especially as the data making up these figures is graphed.

Anyone's guidance appreciated.

P.S.: I am subscribed to the LO-Users mailing list

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.