Ashamed to ask but cannot get VLOOKUP to work.I am trying to look up the value in column A in sheet 1 in sheet 2 column 1 and insert the value found in column 10 in sheet 1. Neither sheets are sorted.
=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64,10,0)As I understand things 'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64 is supposed to define the array in which to search and I thought the $ signs fixed the range but no, when I copy the formula down the page the array changes.
Where am I going wrong please? Budge --- This email has been checked for viruses by AVG. https://www.avg.com -- 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