On 01/08/2018 12:37, Budge wrote:
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
I think I have it. Should have been:-
=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A$2:$L$64,10,0)
Please forgive false alarm
Budge.
---
This email has been checked for viruses by AVG.
https://www.avg.com
--
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
