Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

On 2022/08/08 23:55, Michael H wrote:
> 1. Vlookup can only return columns to the left of the column you search 
> so you need to introduce the date into a leftward column (N2=B2, copy 
> it, paste into column N, all rows)

All the examples I see on the net show that the left most column is the 
one used as the Search Criteria?

In my formulae all state the range from column B, being the left most 
column and include the columns to the right as the one who data I am 
seeking when a match is made in the left most column.

> 2. =vlookup(Max($rawdata.$B2:$M$62037),$rawdata.$b$2:$N63037,12,0)
SO NOW I HAVE A DATE IN THE LEFT MOST AND RIGHT MOST COLUMN?

??

Hylton

--
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