I have list of employees in column A and there corresponding salaries in column B
In cloumn C i have some random employess number
I need salary of column C employees in cloumn D ,which may or may not present in column A and B.
A B C D
1 x 1 x
2 y 5 m
3 z
4 f
5 m
6 g
(above is an just example)
So in column D i need salaries of column c employees
I have totally 325 employees in column A and 76 employees in Column C .
Please help me
I am new to excel
thank u
Last edited by bharathn999; 09-02-2014 at 09:45 AM.
in D1
=VLOOKUP(C1,A$1:B$325,2,0)
and copy down column D
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks for your reply
But i am getting - #N/A in all the columns
Thanks for your reply
But i am getting - #N/A in all the columns
Hi try this In d1
=iferror(index(B:B,match(C1,A:A,0)),"")
Punnam
Try
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
I made a mistake there was a space before the employee numbers in column C,so it was showing N/A
i removed it and tried, It worked like a CHARM!!!
Thank you Special-k ,
and Thank u punnam and boopathiraja
I made a mistake there was a space before the employee numbers in column C,so it was showing N/A
i removed it and tried, It worked like a CHARM!!!
Thank you Special-k ,
and Thank u punnam and boopathiraja
@ Bharath,
If u r question solved , mark the thread Solved by using the THREAD TOOLS,
U can also thank one u helped you bu adding reputations points, using the "Star" Add Reputation.
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks