Input cell value based on multiple dropdown list to populate

[sathishsusa]

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...

[sathishsusa]

Can any one pls solve this issue...

[mana]

H6:=IFERROR(INDEX(B:B,MATCH(J6,C:C,0)),"")
I6:=IFERROR(INDEX(D,MATCH(J6,C:C,0)),"")
K6:=IFERROR(INDEX(E:E,MATCH(J6,C:C,0)),"")

[sathishsusa]

Hi Mana ,

Thanks for reply and its worked perfectly thanks a lot...