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
On 21/07/17 11:32, Budge wrote:
I am using a formula to fill in a cell. The formula is in cell J2
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table a
I am using a formula to fill in a cell. The formula is in cell J2
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table and enters it into cell J2.
I wa