Clélia-elsa has attended:
Excel Advanced course
3 dimension look up
Hi
I recently attended the advanced excel training and have a question related to 3 dimension look up.
I have data ordered in a table in this way.
Column A contains countries
Column B contains metric
Column C contains year
Column D contains the unique value
There are 5,000 rows of data and I need a solution to look up values, asking excel 3 variables (country, metric and year) to get the value.
Using index and match, which formula can I use ?
Many thanks
RE: 3 dimension look up
Hi Clélia-elsa,
Thank you for the forum question.
I have attached an example file where you can see two options.
You may need a Sumifs function or turn a Index & Match function into an array formula.
Have a look at my example and please let me know if it makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
3d lookup.xlsx
