New
#1
Using HLOOKUP & VLOOKUP to pick data from another Worksheet
Hi all
I am creating a table at work, which lists the sales managers for different products and then further sub-sorted for different locations.
The old table had every name manually filled into it. Now, I have to update the table as new people have come in and existing ones have left etc. I was wondering whether instead of manually updating each and every name, if I could create a new table in a new worksheet which holds the names and e-mails of the personnel and the main table can refer the names from this table? So after doing this, in the future if any changes are to be made again, I only have to update the table in sheet 2 instead of updating the entire table in sheet 1.
Here is the outline of the tables in Question:
Here is Sheet 1 which contains the name & e-mails of personnel based upon location and designation. I want to lookup the data for name and e-mail from the table in Sheet 2
Here is Sheet 2 which contains the name and e-mails of the personnel.
So can this be done? Any help would be greatly appreciated! :)