sathishsusa
02-10-2017, 06:11 PM
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...
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...