Autopopulate data depending on the selection from the dropdown list

Hi Guys

Need some assistance to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.

Attached files for reference.

Many thanks in advance for assistance.

lookup should work, but I am trying to test it and its not working, I am looking into why.

ok you can use nested IF statments. Lookup is easier but it is not reading the month titles correctly. so if b1 is your dropdown box and the month name is in monthlydatab1 then you would use IF($b$1=monthlydata!$b$1,monthlydata!b2,if($b$1=monthlydata!$c$1,monthlydata!c2 etc.

if you can get lookup to work then let me know. if not i hope this helps.

Yes and you can also use sumif function for your requirement, herewith I attached the sample sheet