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
Hello Haytham,
I've been experimenting with the formula for some time now, but i can't seem to get it right. See the attached image.
I think I copied your example correctly. Do I need a newer version of Excel maybe?
Thank you in advance!
Kind regards,
Rutger
Hi,
You don't have to a new version of Excel!
The formula should work in any version.
As the attached image, I don't see any typo or something wrong in the formula!
Please make sure that the text (no of shares) is completed in cell J7 and doesn't have any leading spaces.
Same thing with the texts in column D.
Hi Haytham,
Thanks for your help, but it still won't work. I don't know why it won't. I'm calling in some local Excel expert.
Thanks again!
Kinds regard,
Rutger