Hi,
I've been trying to figure out a way to do the following with no luck.
If I have a text value in one cell, is there a way to use that as part of the formula for another cell?
For example:
Cell A12 contains the number 15
Cell B8 contains a match() formula. I want the lookup array of the match formula (e.g. $13:$13) to update with whatever number is entered in A12. For example, entering 15 in A12 would result in a lookup array $15:$15 in my match formula.
I hope that makes sense.
Thanks for your help
Bookmarks