SOLVED

First time posting. Beginner Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1636594%22%20slang%3D%22en-US%22%3EFirst%20time%20posting.%20Beginner%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636594%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ESheet1%20is%20a%20list%20of%2020%20Names%20in%20column%20A%20with%20their%20corresponding%20shoe%20size%20in%20column%20B.%26nbsp%3B%20I%20have%20pulled%205%20Names%20from%20Sheet1%20Column%20A%20onto%20Sheet2%2C%20and%20would%20like%20to%20use%20a%20formula%20to%20populate%20the%20corresponding%20shoe%20size%20from%20Sheet1%20onto%20Column%20B%20in%20Sheet2.%26nbsp%3B%20What%20is%20the%20best%20formula%20to%20use%3F%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERene'%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1636594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1636669%22%20slang%3D%22en-US%22%3ERe%3A%20First%20time%20posting.%20Beginner%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782532%22%20target%3D%22_blank%22%3E%40Rene_Chambliss%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20try%20the%20VLookup%20formula%20to%20get%20the%20desired%20info%20in%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20B2%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFERROR(VLOOKUP(A2%2CSheet1!A%3AB%2C2%2C0)%2C%22Not%20Found%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20copy%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1636752%22%20slang%3D%22en-US%22%3ERe%3A%20First%20time%20posting.%20Beginner%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThank%20You%20Very%20Much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1637002%22%20slang%3D%22en-US%22%3ERe%3A%20First%20time%20posting.%20Beginner%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782532%22%20target%3D%22_blank%22%3E%40Rene_Chambliss%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20If%20that%20takes%20care%20of%20your%20original%20question%2C%20please%20take%20a%20minute%20to%20accept%20the%20post%20with%20the%20solution%20provided%20as%20a%20Best%20Response%20in%20order%20to%20mark%20your%20question%20as%20Solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1637109%22%20slang%3D%22en-US%22%3ERe%3A%20First%20time%20posting.%20Beginner%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782532%22%20target%3D%22_blank%22%3E%40Rene_Chambliss%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Microsoft%20365%20users%20XLOOKUP%20has%20replaced%20VLOOKUP.%26nbsp%3B%20Using%20a%20table%20for%20the%20data%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%20XLOOKUP(Name%2C%20tblData%5BName%5D%2C%20tblData%5BSize%5D%2C%20%22Not%20listed%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EFor%20everyone%20else%2C%20you%20are%20stuck%20with%20the%20nations%20favourite%2C%20VLOOKUP%2C%20or%20you%20could%20turn%20to%20INDEX%2FMATCH.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

Sheet1 is a list of 20 Names in column A with their corresponding shoe size in column B.  I have pulled 5 Names from Sheet1 Column A onto Sheet2, and would like to use a formula to populate the corresponding shoe size from Sheet1 onto Column B in Sheet2.  What is the best formula to use?

Thank you,

Rene'

5 Replies
Best Response confirmed by Rene_Chambliss (New Contributor)
Solution

@Rene_Chambliss 

You may try the VLookup formula to get the desired info in column B.

 

In B2

=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,0),"Not Found")

and copy it down.

 

 

@Subodh_Tiwari_sktneer   Thank You Very Much!

@Rene_Chambliss 

You're welcome! If that takes care of your original question, please take a minute to accept the post with the solution provided as a Best Response in order to mark your question as Solved.

@Rene_Chambliss 

For Microsoft 365 users XLOOKUP has replaced VLOOKUP.  Using a table for the data

= XLOOKUP(Name, tblData[Name], tblData[Size], "Not listed")

For everyone else, you are stuck with the nations favourite, VLOOKUP, or you could turn to INDEX/MATCH.

@Peter Bartholomew Thank You Very Much!  I will go research that option now.