Microsoft Tech Community Live: Microsoft Viva Edition
November 16, 2021, 08:00 AM - 12:00 PM (PST)

Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2118333%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118333%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20sure%20if%20this%20has%20been%20addressed%20before%20but%20I%20am%20looking%20for%20a%20formula%20that%20would%20allow%20me%20to%20pull%20data%20from%20one%20sheet%20to%20another.%20Something%20like%20this....%20If%20the%20info%20matches%20up%20I%20want%20to%20pull%20the%20city%20from%20Sheet%202%20to%20sheet%201.%26nbsp%3B%20I%20can't%20just%20sort%20and%20add%20because%20there's%20more%20information%20on%20one%20sheet%20than%20the%20other.%26nbsp%3B%20Hope%20that%20makes%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%3C%2FP%3E%3CTABLE%20width%3D%22300px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22139px%22%20height%3D%2230px%22%3EName%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3EAge%3C%2FTD%3E%3CTD%20width%3D%2262px%22%20height%3D%2230px%22%3EWeight%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ECity%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139px%22%20height%3D%2230px%22%3EJane%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2262px%22%20height%3D%2230px%22%3E120%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139px%22%20height%3D%2230px%22%3EBob%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E37%3C%2FTD%3E%3CTD%20width%3D%2262px%22%20height%3D%2230px%22%3E182%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139px%22%20height%3D%2230px%22%3ESam%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E22%3C%2FTD%3E%3CTD%20width%3D%2262px%22%20height%3D%2230px%22%3E145%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139px%22%20height%3D%2230px%22%3EMolly%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2262px%22%20height%3D%2230px%22%3E130%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%202%3C%2FP%3E%3CTABLE%20width%3D%22270px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3ECity%3C%2FTD%3E%3CTD%20width%3D%2268px%22%20height%3D%2230px%22%3EName%3C%2FTD%3E%3CTD%20width%3D%2257px%22%20height%3D%2230px%22%3EAge%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3EWeight%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3EChicago%3C%2FTD%3E%3CTD%20width%3D%2268px%22%20height%3D%2230px%22%3EJane%3C%2FTD%3E%3CTD%20width%3D%2257px%22%20height%3D%2230px%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3E120%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3EDallas%3C%2FTD%3E%3CTD%20width%3D%2268px%22%20height%3D%2230px%22%3EBob%3C%2FTD%3E%3CTD%20width%3D%2257px%22%20height%3D%2230px%22%3E37%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3E182%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3ELebanon%3C%2FTD%3E%3CTD%20width%3D%2268px%22%20height%3D%2230px%22%3ESam%3C%2FTD%3E%3CTD%20width%3D%2257px%22%20height%3D%2230px%22%3E22%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3E145%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3EAtlanta%3C%2FTD%3E%3CTD%20width%3D%2268px%22%20height%3D%2230px%22%3EMolly%3C%2FTD%3E%3CTD%20width%3D%2257px%22%20height%3D%2230px%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2230px%22%3E130%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121296%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121296%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959894%22%20target%3D%22_blank%22%3E%40almaalllen%3C%2FA%3E.%20Using%20a%20vlookup%20should%20give%20you%20what%20you%20are%20looking%20for.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20need%20more%20detailed%20assistance%2C%20try%20the%20Excel%20Tech%20Community%2C%20there%20are%20many%20more%20Excel%20experts%20over%20there%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

NameAgeWeightCity
Jane25120 
Bob37182 
Sam22145 
Molly40130 

 

Sheet 2

CityNameAgeWeight
ChicagoJane25120
DallasBob37182
LebanonSam22145
AtlantaMolly40130

 

1 Reply

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