Here is my situation:

-A user enters one of any number in an input cell. Say for example he
enters 10.
-I need to look at cell B12 in this case (actually will always be "B" &
input_number +2, so if they enter 5, I need to look at B7).
-Now I need to look at the contents of this cell B12, which contains the
word "Jim" for example. I then need to compare cell B12 (or whatever cell,
as this will vary), to the next cell down, B13, see if B12=B13.

There may be an easy way to do this, but I can't get it to work. I tried
creating a variable, that took input_number and converted it to "B" & input
number +2. So now I have a varaible that = B12 (will vary based on their
input number). Then tried do =CELL("contents", variable) to pull out the
value of "Jim". Didn't work. I can't enter in B12 here, because that will
vary. Thought the dynamic variable would accomplish that, but doesn't seem
to work.

Any help appreciated. Thanks