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+unsubscr...@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
