Hi,
i have created table for lookup data from "B4:E15" and i created a data validation list on other columns. Now what i need if i enter the value of Employee id in column "J " which indicates in yellow color the other dropdown list column in " H, I, K" to display the correct information to populate based on the Lookup table.
pls see the attachment file for example...
Remove "DataValidationList" from column "H" "I" "K"
Input formula "H6"Formula:
Please Login or Register to view this content.
"I6"Formula:Please Login or Register to view this content.
"K6"Formula:Please Login or Register to view this content.
copy paste drag down till end.
Ensure This a Array formula [SHIFT+CTRL+ENTER]
File attach.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Dear Avk,
thanks for reply its working perfectly thanks a lot dude.....
avk pls have a request for you can u solve my previous thread after that i expecting from you to solve its that thread not solved.... pls solve if u any idea
http://www.excelforum.com/excel-prog...ml#post4580740
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks