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
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:
=VLOOKUP(MAX(A1,D1,G1),B1:H1,FALSE) = #N/A
=MATCH(INDEX(A2),A1:H1,0) = #N/A
=HLOOKUP(MAX(A1,D1,G1),A1:H1,1,0) =60 BEING THE SAME VALUE AS MAX().
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: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] LO 220.127.116.11 CALC : Appropriate formula? · Hylton Conacher (ZR1HPC)
Impressum (Legal Info)
: 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