Excel problem
Solved/Closed
John
-
Updated by John on 21/03/17 at 09:09 AM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Excel problem
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
2 replies
Mazzaropi
Mar 22, 2017 at 06:59 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Mar 21, 2017 at 11:50 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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