SOLVED

First time posting. Beginner Excel

Copper 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 (Copper 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.  

1 best response

Accepted Solutions
best response confirmed by Rene_Chambliss (Copper 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.

 

 

View solution in original post