Populating a report sheet with lookup values

Topic

New Reply

Hello all,

It’s been a good while since I last posted here.

Have a dashboard which I want to populate with data depending on the selected service name and selected month.
I have set up my dynamic named lists and created the dropdowns at the top of my dashbaord and now I want to be able to populate various areas of the dashboard using information held in tables in other sheets.

I want a formula that looks up the date and the service name and can then supply me with the figure from the table.
I am sure this is very straight forward, but I only know about VLOOKUP and HLOOKUP and it seems I need some sort of combination of the two.

I’m not sure I have explained this problem very well, I hope you can help.

Thanks

Emily

Reply | Quote

Replies

Welcome back to the Lounge!

You can probably use a combination of INDEX and MATCH. The formula could look like this:

=INDEX(table, MATCH(selected_service, list_of_services, 0), MATCH(selected_month, list_of_months, 0))

but of course the exact form depends on the layout of your data. If you’d like more specific help, it would be useful if you could attach a small sample workbook.

Reply | Quote

Thanks Hans, I’ll give it a go.

Reply | Quote

I am now investigating a combination of VLOOKUP and MATCH.

Reply | Quote