I have one spreadsheet which contains c 500 account numbers. I want to populate this with data from another spreadsheet, which contains c50000 account numbers and various other info (addresses etc). I only want the data for the 500 accounts.
Is there any way to do this?
I've tried doing a VLOOKUP but it doesn't seem to work.
TIA.
Is there any way to do this?
I've tried doing a VLOOKUP but it doesn't seem to work.
TIA.
0 commentaires:
Enregistrer un commentaire