=IF statement to pull from another sheet

[boxermack]

Hello,

I am trying to do the following:

I want to use, let's say, Column B as the empty field to have a statement saying, If Column A has (John Doe) typed in it, then Column B will fill in the information associated with John Doe. So, Column A would be the person's name. Column B is the field I want to have, let's say their hire date populated. Is there a way to have the hire date list hidden somewhere on the same sheet OR a separate sheet that it will pull and recognize the data and auto fill for me?

I hope that makes sense. THANKS IN ADVANCE!!

[TMS]

You need to set up a data table somewhere, if you do not have one, ideally on a separate sheet. Forget column should be the "key field", the person's name. Columns following that will be the data relating to that person.

Then you can use VLOOKUP to return the matching information.


Regards, TMS

[boxermack]

Thanks, I researched the VLOOKUP more and it works great.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.