Excel problem

Solved/Closed
John - Updated by John on 21/03/17 at 09:09 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Mar 22, 2017 at 06:59 AM
Hello,

I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell.

Ex:

Emp No Name
1 John
2 David
3 Abraham
4 Joseph
5 Alfred


Now, If I type 1, the name should automatically appears in adjacent cell.

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Mar 22, 2017 at 06:59 AM
Thanks for the feedback.

Glad I could help.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Mar 21, 2017 at 11:50 AM
john, Good morning.

VLOOKUP Function will work perfectly for you.

SUPPOSE:

..........N..............M
1....Emp No........Name
2........1............John
3........2............David
4........3............Abraham
5........4............Joseph
6........5............Alfred

TRY TO USE:

A1 --> TYPE EMP NO DESIRED

B1 --> =VLOOKUP(A1, N2:M6, 2, FALSE)

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
-1
Thanks a lot Belo Horizonte

It works.
0