Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1519985%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519985%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20reaching%20out%20because%20I'm%20not%20very%20familiar%20with%20excel%20formulas.%20What%20I'm%20looking%20for%20is%20to%20have%20a%20City%20Column%20and%20County%20Column.%20For%20example%2C%20if%20I%20put%20a%20city%20such%20as%20San%20Francisco%20(Column%20H)%2C%20I%20want%20the%20County%20Column%20(Column%20I)%20to%20populate%20with%20the%20set%20County%20Code.%20There%20are%20roughly%205%2B%20County%20Codes%20that%20will%20be%20correlating%20with%20a%20numerous%20number%20of%20cities%20in%20California.%20The%20data%20in%20which%20I%20want%20this%20information%20to%20be%20pulled%20from%20is%20in%20a%20secondary%20tab.%20So%2C%20essentially%20when%20I%20input%20the%20city%20in%20the%20City%20Column%20(Column%20H)%20I%20need%20the%20County%20Column%20(Column%20I)%20to%20auto%20fill%20by%20pulling%20the%20associated%20data%20from%20the%20second%20tab.%20Sorry%20for%20any%20redundancies%20and%20thanks%20for%20the%20help!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1519985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520145%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F727495%22%20target%3D%22_blank%22%3E%40vjnaicker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you're%20describing%20sounds%20exactly%20like%20what%20you%20need%20is%20the%20%3CSTRONG%3EVLOOKUP%3C%2FSTRONG%3E%20function.%20If%20you'd%20upload%20a%20sample%20of%20your%20file%2C%20I%20or%20somebody%20else%20could%20create%20the%20formula%20for%20you.%20But%20perhaps%20you'd%20rather%20do%20it%20yourself.%20It's%20not%20hard.%20Use%20the%20Excel%20Help...or%20search%20on%20Google%20for%20how%20to%20use%20that%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20allegedly%20something%20like%20the%20third%20most%20popular%20function%20in%20all%20of%20Excel...well%20worth%20becoming%20acquainted%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20make%20sure%20that%20if%20you%20do%20post%20a%20sample%20of%20your%20file%2C%20that%20it%20not%20include%20any%20private%20or%20confidential%20info.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520150%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520150%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there!%20Thanks%20for%20the%20insight.%20I%20was%20finally%20able%20to%20get%20it%20to%20work.%20The%20formula%20that%20I%20ended%20up%20using%20was%26nbsp%3B%3DIFNA(VLOOKUP(%24H2%2C'City-County'!%24A%3A%24B%2C2%2CFALSE)%2C%22%22).%20That%20seemed%20to%20do%20what%20I%20was%20looking%20for.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

Hello! 

 

I'm reaching out because I'm not very familiar with excel formulas. What I'm looking for is to have a City Column and County Column. For example, if I put a city such as San Francisco (Column H), I want the County Column (Column I) to populate with the set County Code. There are roughly 5+ County Codes that will be correlating with a numerous number of cities in California. The data in which I want this information to be pulled from is in a secondary tab. So, essentially when I input the city in the City Column (Column H) I need the County Column (Column I) to auto fill by pulling the associated data from the second tab. Sorry for any redundancies and thanks for the help!! 

2 Replies

@vjnaicker 

 

What you're describing sounds exactly like what you need is the VLOOKUP function. If you'd upload a sample of your file, I or somebody else could create the formula for you. But perhaps you'd rather do it yourself. It's not hard. Use the Excel Help...or search on Google for how to use that function.

 

It's allegedly something like the third most popular function in all of Excel...well worth becoming acquainted with.

 

Just make sure that if you do post a sample of your file, that it not include any private or confidential info.

Hey there! Thanks for the insight. I was finally able to get it to work. The formula that I ended up using was =IFNA(VLOOKUP($H2,'City-County'!$A:$B,2,FALSE),""). That seemed to do what I was looking for. @mathetes