Forum Discussion
Referring to a certain cell; but its not on the same row each time
Hi,
Sorry, but your request isn't clear enough!
But I'll give you a solution (I hope it's what you're looking for).
You can use INDEX & MATCH combination to find the intersection point in a table based on two criteria.
In the example below, the intersection point of the Customer1 row and the Year 2018 column is cell E2.
Try to change the Customer name and the Year and see how it works.
Please find that in the attached file.
Hope that helps
Hi,
Sorry, but your request isn't clear enough!
But I'll give you a solution (I hope it's what you're looking for).
You can use INDEX & MATCH combination to find the intersection point in a table based on two criteria.
In the example below, the intersection point of the Customer1 row and the Year 2018 column is cell E2.
Try to change the Customer name and the Year and see how it works.
Please find that in the attached file.
Hope that helps
This comes REALLY close to what I'm looking for. Thanks alot Haytham! This will help me alot further!
Kind regards,
Rutger