This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I'd like to display a number based on text entered in the cell preceding it (all based on pre-populated cells from another sheet). Ex: Sheet1 has 20 names in A1-A20 and their corresponding "number" in B1-B20 - all entered manually. On Sheet2 I would like to be able to type a person's name in a random A cell and automatically have the person's value appear in the B cell next to it (according to their number in Sheet1).
Is this possible? Any help is very much appreciated.
Thank you.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
In B1 of Sheet2 enter this then copy down to B20
=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$20,2,FALSE)),"",VLOOKUP(A1,Sheet1!$A$1:$B$20,2,FALSE))
Enter person name in Sheet2 column A
Gord
Answer accepted by question author
Hi, Assuming you enter the name in A1 in sheet2 in another cell enter
=index(sheet1!$B$1:$B$20,match(A1,sheet1!$A$1:$A$20,0))