Is it possible to use
VLOOKUP with an external spreadsheet?
SpreadsheetAcontains a set of a few hundred addresses.
SpreadsheetBis an invoice.
- I want to use
VLOOKUPin the invoice to return addresses from
I tried things like:
but that doesn't work.
Is it possible at all? If so, can somebody teach me how to do it?
The spreadsheet with addresses (A) is a Google Sheet. I want to have all of my addresses in a central place, where I can use them for more than one purpose, e.g. invoices, mailings, etc.
The other spreadsheet (B) is currently a LibreOffice sheet, but I would be prepared to convert it to a Google Sheet if that could solve my problem. Seen the fact that I need individual PDF's of every invoice, Google Sheets isn't my first choice.