Here's my scenario:
I find the row in a table using the "match" function. Can I use this value to reference a cell in the row I've found.
For example, if, in cell B7, the match function returns a value of 3. Can I use the value in cell B7 to reference a particular cell in row X (I'm looking to get a cell address of X3, so that I can decrement the value in cell X3 by 1.)
Thanks in advance.