PDA

View Full Version : [SOLVED] Input cell value based on multiple dropdown list to populate



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

sathishsusa
02-11-2017, 06:13 AM
Can any one pls solve this issue...

mana
02-11-2017, 10:40 PM
H6:=IFERROR(INDEX(B:B,MATCH(J6,C:C,0)),"")
I6:=IFERROR(INDEX(D:D,MATCH(J6,C:C,0)),"")
K6:=IFERROR(INDEX(E:E,MATCH(J6,C:C,0)),"")

sathishsusa
02-12-2017, 03:58 AM
Hi Mana ,

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