Vlookup tool
Hello All,
I am trying to find out a way where i can fill data from Week ending table for Employee performance. What i am trying to do is if Weekending Match Tab name than search for employee Id and return value which i need (Name, Absent Hours, Schedule Hours Etc)
I tried Vlook its not working its giving me error. Help me please!
P.S I have attached file to give clear picture of what i am trying to do. please help me
See attached.
This is amazing, You are Grea Work. Now if i have same kind of table below also. which shows their KPI, Then i just need to change indirect formula? Can you help me with that please.
Is there any way that i can keep this file separate and sheet which you made it in separate file.
Please Help me. I really need this to be working
Last edited by crescendo; 08-06-2014 at 03:22 PM.
The numbers 5,6, and 4 are the column references. If you'd like a different column, just changes those numbers.
It is in same Column but different raw. Please help. I have attached file with additional information. There are 4 tables i have only made two here just to know how to do it than i will reference it by my self.
Again i really appreciate your help
You just need to update the table's location. And change the column references to match up with the data you want. Let me know if you have any questions.
You are amazing man. I really appreciate it.
Thank You
Sure thing. Let me know if you have any more questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks