Formula help

[almaalllen]

I'm not sure if this has been addressed before but I am looking for a formula that would allow me to pull data from one sheet to another. Something like this.... If the info matches up I want to pull the city from Sheet 2 to sheet 1.  I can't just sort and add because there's more information on one sheet than the other.  Hope that makes sense. 

Sheet 1

Name	Age	Weight	City
Jane	25	120
Bob	37	182
Sam	22	145
Molly	40	130

Sheet 2

City	Name	Age	Weight
Chicago	Jane	25	120
Dallas	Bob	37	182
Lebanon	Sam	22	145
Atlanta	Molly	40	130

[#2]

Hi @almaalllen. Using a vlookup should give you what you are looking for.

If you need more detailed assistance, try the Excel Tech Community, there are many more Excel experts over there: https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat