Index & Match from table With Drop Down List

Hello,

I have a table with drop down list selection, When I select a program from the drop down menu in Program column in this table

The other fields in the row should be filled automatically with data from the table in programs list sheet, on the same row relative to the program selected here. code, hours, number and type.

I used VLOOKUP, INDEX MATCH, but all didn't for for me, maybe because it's a drop down menu selection.

So I am missing something and can't find it

Attached the excel workbook.

Thanks for all who can help me sort it out.

Hi
Try this -
In D4: =INDEX('Programs List'!E:E, MATCH($C$2,'Programs List'!$C:$C,0))

E4 =INDEX('Programs List'!D:D, MATCH($C$2,'Programs List'!$C:$C,0))

F4 =INDEX('Programs List'!F:F, MATCH($C$2,'Programs List'!$C:$C,0))

Thank you it works Thanks a lot for helping

Great, you're welcome.