Forum Discussion
If, Index & Match formula help required
I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim". I have two formuals as per below that work independently of each othe...
Hi Steven,
Try exploring Indirect function which you can use here.
As you already know about complex formula, you can easily customize it to suit your need. thanks.
Regards,
DILIPandey