Excel problem
Solved/Closed
John
-
Updated by John on 21/03/17 at 09:09 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 22, 2017 at 06:59 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 22, 2017 at 06:59 AM
Related:
- Excel problem
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 22, 2017 at 06:59 AM
Mar 22, 2017 at 06:59 AM
Thanks for the feedback.
Glad I could help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Glad I could help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 21, 2017 at 11:50 AM
Mar 21, 2017 at 11:50 AM
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
