Excel problem [Solved/Closed]

Report
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
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

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Thanks for the feedback.

Glad I could help.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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
Thanks a lot Belo Horizonte

It works.