Change the number portion of cell reference

[ExcelAtEverything]

This is separate from my earlier post which asked this question. In my earlier post, midway thru I grouped it with another issue and my issue never really got resolved. It's my own fault because I lost focus & mis-stated/misrepresented my issue. So this time I'll try asking without any attachment example, and try to stay focused on my exact issue.

Simply put:

--> This is the formula I have in a cell: =B1
--> I want to be able to change that number portion of the formula (the "1") to reflect the contents of cell G7.
--> The following is a fictional formula to replace the "=B1" formula from above, which represents what I'm asking for: =B{{G7}}
--> In that fictional formula, it would do the same thing as the initial "=B1" formula, except the {{G7}} part would swap the "1" out of the original formula with whatever value happens to be in cell G7.

Thanks!

 

[steve the fish]

=INDEX(B:B,G7)

 

[Fluff]

How about

=INDEX(B:B,G7)

 

[ExcelAtEverything]

Excellent! (no pun intended)
Thx Fluff & Steve the Fish!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[ExcelAtEverything]