Trying to pull info from a list of names on one sheet to another list of names on another

Hello,

First time poster and low/moderate Excel skill level. I have a workbook with 2 worksheets. Worksheet 1 contains a list of names. Worksheet 2 contains a list of names that includes the names on Worksheet 1 and also includes data in other columns about those names. I am trying to create a formula that allows me to accomplish the following (not in Excel language): If text in column A of Worksheet 1 is the same as text in column A of Worksheet 2, then import data from column C of Worksheet 2 found in the same row as the text in Worksheet 2 that equaled the text from column A of Worksheet 1.

I had been trying to accomplish this with an IF formula that was =IF(A1='Worksheet 2 A1:A100','Worksheet 2 C1:C100',0). That doesn't work. I'm thinking this may be VLOOKUP, which is where my expertise on Excel ends.

Any help would be much appreciated!

Thank you. Shortly after posting this, I got it to work. I just had never used VLOOKUP before, so that was a new one for me. Now I know just enough to be dangerous!