Sep 04 2020 10:46 AM
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'
Sep 04 2020 11:01 AM
SolutionYou 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.
Sep 04 2020 11:21 AM
@Subodh_Tiwari_sktneer Thank You Very Much!
Sep 04 2020 12:20 PM
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.
Sep 04 2020 12:58 PM
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.
Sep 04 2020 02:55 PM
@Peter Bartholomew Thank You Very Much! I will go research that option now.
Sep 04 2020 11:01 AM
SolutionYou 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.