Excel problem [Solved/Closed]
John -
Mar 21, 2017 at 08:39 AM - Latest reply:
Mazzaropi
1834
Posts
Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
- Mar 22, 2017 at 06:59 AM
3 replies
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
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