Excel problem

Solved/Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 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
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
Thanks for the feedback.

Glad I could help.

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