Forum Discussion
Combining two spreadsheets, one has an extra category
Hi, I have two spreadsheets which I would like to combine: spreadsheet 1 is from our client database which includes a client name and the associated department on each row (only for one department, ...
H2Othanks for your help but i'm having issues with consolidation. i don't know which function to use nor which cells to select.
this is an example of spreadsheet 2;
| Client Name | Department |
| Yellow, Andrew | |
| Bello, Anna | |
| Brick, Anna | |
| Ran, Sam |
this is an example of spreadsheet 1;
| Department | Client name |
| XX | Bloggs, Anna |
| XX | Biggs, Anna |
| XX | Brux, Anna |
| XX | Bello, Anna |
| XX | Brick, Anna |
i want to be able to import into spreadsheet 2 the department category for all clients listed in spreadsheet 1 only. but spreadsheet 2 has lots of clients and lots aren't in department X, the department column in spreadsheet 2 is currently blank. does this help explain what i'm after?
thank you
You may use any lookup function, e.g.
=XLOOKUP($A2, Sheet1!$B:$B,Sheet1!$A:$A, "" )Please check in attached.