Hi Everyone
Can anyone help me with the next issue.
I have two big spreadsheets. I need to transfer one column from one spreadsheet to another based on multiple values. For some reason XLOOKUP does not work. It works only for a single value. If I put two or three criteria it returns as SPLITT. The spreadsheets are both have thousands rows. Any help would be much appreciated.
PS. Xlookup does not return the correct value.
I need to allocate a row based on "Amount in local currency" & "G/L Account. I want to "say" if the spready sheet has F3(14.95) and the account number is E3(5602001500), then the purpose should be transferred from another spreadsheet. Thanks in advance.
Rd,
Eugene
Can anyone help me with the next issue.
I have two big spreadsheets. I need to transfer one column from one spreadsheet to another based on multiple values. For some reason XLOOKUP does not work. It works only for a single value. If I put two or three criteria it returns as SPLITT. The spreadsheets are both have thousands rows. Any help would be much appreciated.
PS. Xlookup does not return the correct value.
I need to allocate a row based on "Amount in local currency" & "G/L Account. I want to "say" if the spready sheet has F3(14.95) and the account number is E3(5602001500), then the purpose should be transferred from another spreadsheet. Thanks in advance.
Rd,
Eugene