I have a row in excel that has different names of people and another row next to it full of numbers from 1-2187. I want to make it so that when I type in a persons name, the number in the column next to the persons name comes out. Any help is greatly appreciated! Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,694
- Office Version
- 365
- Platform
- MacOS
rows are the numbers 1 to xxxx down the left hand side
columns are letters across the top
a little confused on your question
in Column A running top to bottom you have a list of names
in Column B running top to bottom you have a list of numbers
where are you typing the name
lets assume its in column C row 1
now in Column D row 1 type
=Vlookup(C1, A:B, 2 , false)
now the number will appear for that name
or
=index(B:B, Match(C1, A:A, 0))
columns are letters across the top
a little confused on your question
in Column A running top to bottom you have a list of names
in Column B running top to bottom you have a list of numbers
where are you typing the name
lets assume its in column C row 1
now in Column D row 1 type
=Vlookup(C1, A:B, 2 , false)
now the number will appear for that name
or
=index(B:B, Match(C1, A:A, 0))
Upvote
0
Similar threads
- Question
