[libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

HI,

USING

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:
=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.

Regards
Hylton
mailto:hylton@conacher.co.za
P.S.: I am subscribed to the LO-Users mailing list


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy