Excel problem [Solved/Closed]

Report
-
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
-
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
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
142
Thanks for the feedback.

Glad I could help.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
142
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!