I have a schedule of games from A2 through A815. The game number being played is in A1. Let's say I'm on game 652 and want to view the results that show in row B652. How do I do this?
I have a schedule of games from A2 through A815. The game number being played is in A1. Let's say I'm on game 652 and want to view the results that show in row B652. How do I do this?
If you mean physically select the cell, press F5 key, type B652 in the dialogue box and press Enter.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
One way...
This formula entered in C1:
=IF(A1="","",INDEX(B:B,A1))
Or, do you actually want a hyperlink that takes you to cell B652?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are a few ways of interpreting what you want. Here are a couple more to consider:
1. If you want to go to B652, enter B652 in the Name Box (left of the formula bar) and hit enter.
2. If the 652 is in A1, you could enter this where you want the contents of B652 =INDIRECT("B"&A1)
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks