A formula that takes an input number to a range?

Do you mean like the users would enter "C25" and be taken to that cell?
Hit the F5 key and see if that suits your needs.

Let me try to explain it better. I was thinking of something like a cell or box where the user inputs a specific id # for example "1001". This number would also be contained in column A of the spreadsheet. I would like the user to enter the number then click on a button "go" and be taken to that cell with the same number. There are more than 4000 lines on this sheet so I'm just trying to make it easier for the user to get to their section. There must be a macro that can be used for this?

Larry, you could try something like this:
Note: assumes
1) ID in Column A (given by you)
2) ID's are numbers (Given by you)
3) ID's are different
4) ID to look for is entered in cell B1
5) To make the entering of the ID easier
for the user Freeze the top row, that way
the user will always have access to B1.

In your sheets code module put this in;

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$B$1" Then
GoToID (Target.Value)
End If
End Sub

In a Prg Module put this code in;

Sub GoToID(ID)
Dim oRow As Double

On Error Resume Next
oRow = Columns(1).Find(ID)
If Err.Number <> 0 Then MsgBox "No match!": End
Application.Goto Cells(oRow, 1), True
End Sub

So that your user selects the ID code @ B1
the worksheet change event is triggered @ B1
and the GoToID is run which will take you here.

HTH

Ivan