hnmurugan Posted September 16, 2009 Author Share Posted September 16, 2009 (edited) Updated to office 2003 file format. The table structure in requirements.xls may not allow lookup conveniently, thus i have changed in vlookup.xls. Requirements_2.zipBased on vlookup.xls, i have tried as below with no luck.D3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,3)E3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,4)F3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,5)Any help is greatly appreciated.RegardsHariVlookup.zip Edited September 16, 2009 by hnmurugan Link to comment Share on other sites More sharing options...
jaclaz Posted September 16, 2009 Share Posted September 16, 2009 See if Vlookup2.xls (actually based on "requirements.xls") suites you. jaclazVlookup2.zip Link to comment Share on other sites More sharing options...
hnmurugan Posted September 16, 2009 Author Share Posted September 16, 2009 Please correct me if i am wrong.Based on quick look on your example Totalhrs is mandatory were as designation is not.I require the designation as mandatory.Example: A employee may work as des1 for day 1 and as des4 for day2.RegardsHari Link to comment Share on other sites More sharing options...
jaclaz Posted September 16, 2009 Share Posted September 16, 2009 Please correct me if i am wrong.Based on quick look on your example Totalhrs is mandatory were as designation is not.I require the designation as mandatory.Example: A employee may work as des1 for day 1 and as des4 for day2.RegardsHariWell, I simply thought that a Driver is a Driver and a Tech is a Tech, and "coupled" "employee#" with Designation.You can simply overwrite the formulas in colums "Designations" and write the Designation manually or choose it from a list.jaclaz Link to comment Share on other sites More sharing options...
hnmurugan Posted September 16, 2009 Author Share Posted September 16, 2009 Please correct me if i am wrong.Based on quick look on your example Totalhrs is mandatory were as designation is not.I require the designation as mandatory.Example: A employee may work as des1 for day 1 and as des4 for day2.RegardsHariWell, I simply thought that a Driver is a Driver and a Tech is a Tech, and "coupled" "employee#" with Designation.You can simply overwrite the formulas in colums "Designations" and write the Designation manually or choose it from a list.jaclazNoted. Thanks for your help.I figure out why below was not workingD3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,3)E3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,4)F3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,5)Changed as below and changed the designation column value in tables sheet as DES1_4, DES1_8 and so on. It's working now.D3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,3)E3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,4)F3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,5)Hmm...It is not over yet... Give me some time to test and will post back the results with 1 last requirement.Once agin thanks fro your help. Link to comment Share on other sites More sharing options...
hnmurugan Posted October 1, 2009 Author Share Posted October 1, 2009 Hi jaclaz ,Sorry. Did not have chance to say thank you last 2 weeks. Really appreciate your help and i was able to achieve what i want. Best wishes.regardsHari Link to comment Share on other sites More sharing options...
jaclaz Posted October 1, 2009 Share Posted October 1, 2009 Only too happy of having been of help. jaclaz Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now