Pull data from another tab if names match

Question

Hello,

I need help with a formula to pull data in to image #1 columns D-H based on if the name matches the name in image #2. So if the name in Column C in image #1 matches the name in Column D of image #2, then column E's data in image #2 would pull in to column D in image #1. Same for the rest of the columns. To take it a step further, not all names will appear in image #2, and in that case I would need the formula to return "0". 

Answer 1

https://1drv.ms/x/s!ArpQN4kTH-8FiG156t0ow6dC?e=X0dx3Q

Here is the OneDrive link to the file. I removed all of the formulas that I had tried to provide a clean version.

Answer 2

Thanks for sharing your file

You may download it from the link below with the answer

https://1drv.ms/x/s!AjGRD1TlwpAGnRRw5BBcE1ZpWElb?e=vDlpaL

Notes:

1- There are no matching values in any of the tables you provided, therefore the formula returns an #N/A error, then replaced by the IFERROR() formula.  (check the picture below)

2- IMHO, rather than lookup by the Employee names, would be better lookup by Employee ID's which are (should be) a unique Identifier for each person

So I switched columns in both tables to make the Emp ID's to the far left of the table to be used by the VLOOKUP() formula.

The video below will give you further info

https://www.youtube.com/watch?v=d3BYVQ6xIE4&t=587s

Do let me know if you need more help

On the other hand,

If the answer helped you.

Please, consider marking this thread as answered.

It would help others in the community with similar questions or problems.

Thank you in advance

Regards

Jeovany