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

Hi Laurie

The video in the link below will guide you and provide a solution to your question.

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany

https://www.youtube.com/watch?v=iJ1MO2xx8wQ&t=187s

Answer 2

Thanks for your response, unfortunately the formula returns #N/A. Any suggestions?

Answer 3

Wrap your formula with IFERROR() function

=IFERROR(Your VLOOKUP formula,"")    if you want to return BLANK

=IFERROR(Your VLOOKUP formula,0)    if you want to return 0 (Zero)

=IFERROR(Your VLOOKUP formula,"No info Available")    if you want to return "No info Available"

For more detailed info check the video below

https://www.youtube.com/watch?v=bKLvtgP8XSs

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany

Answer 4

Thank you again for your response. The formula using =IFERROR does pull data in to my worksheet, however the data is not accurate based on the name. I am not sure what is wrong and why it is pulling another person's data. Any idea?

Answer 5

Thank you again for your response. The formula using =IFERROR does pull data in to my worksheet, however the data is not accurate based on the name.I am not sure what is wrong and why it is pulling another person's data. Any idea?

It is difficult to give you an answer without having access to your file and check what is wrong

Kindly suggest prepare and upload a copy of the file to Onedrive, Dropbox, etc ... and share the link here

If you need help with how to do it please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07