Excel problem [Solved/Closed]

Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Thanks for the feedback.

Glad I could help.

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