Hello,
An answer your V/HLOOKUP question:
HLOOKUP searches for a value on a row (Horizontally) and then goes down
to fetch the corresponding entry on a lower rowVLOOKUP searches for a
value in a column (Vertically) and then goes across to fetch the
corresponding entry on a column to the right
In
At 13:50 15/09/2020 +0200, Hylton Conacher wrote:
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
First attempt. List removed the formating and stripped the greater than
signs?? So, manual turned off rich text, and see what this attempt looks
like.
If I understand your issue?? Don't know if this will come thru OK.
Put these vaues in row 1 and formula in A2 and B2.
Change Date to my format.
=If I understand your issue?? Don't know if this will come thru OK.
Put these vaues in row 1 and formula in A2 and B2.
Change Date to my format. Changed values in D1,A1, and G1, and got
the matching date when it was larger.
25
07/01/20
60
05/09/20
30
07/26/20
60
05/09/20
A2:
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