go to a specific row in excel

[reddcannon]

Using windows 10
office 2016
I want to type a dollar amount in cell b4 and have it go to the row in column "A" between cells a6:a113
I have tried so many ways, like vlookup, match, find etc and nothing is working. Can someone help please

 

[reddcannon]

returns with the following
=ISNUMBER(B4) TRUE
=LEN(B4) 6
=ISNUMBER(A40) TRUE
=LEN(A40) 6

I left it as A40 and used that value 252900 in B4 because A40 is 252900 again not finding it I changed it all to general so there are no decimals

 

[reddcannon]

returns with the following
=ISNUMBER(B4) TRUE
=LEN(B4) 6
=ISNUMBER(A40) TRUE
=LEN(A40) 6

I found the problem , it works, thanks so much

 

[Joe4]

What was the issue?

Also Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.

 

[reddcannon]

What was the issue?

Also Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.

Issue was i had it password protected