I have LibreOffice installed on Linux Mint. I also have 5.4.5.1 installed on
a Windows 8.1 x64 HP laptop. I also have 5.4.7 installed on Windows 7 x64.
All run fine.
Now I installed 5.4.7 on a desktop running a fresh copy of Windows 8.1 x64.
This desktop is 6-7 years old and a twin of the system r
Hope this helps:
I have a general Ledger spreadsheet. 1 of the pages is a chart of accounts:
COL A COL B
1234 (Account Number) Rent (Account Name)
Another page is cash account data entry:
Account _ Data entry (must match the entry in the char
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
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
