Find a number within a range

A

ayazgreat

Well-known Member
Joined
Jan 19, 2008
Messages
1,151
Sir
I want to ask subject question , all I wanted to do is ask that can it be possible, we can find a number within a range through user form.

In a workbook ,having 4 or 5 sheets , diffrent ranges are scattered with their start range and end range like mentined below
Start Range End Range
2100100 2100199
2130100 2130199

If I want to search number like 2100125, then a user form finds it and goes to that cell containing searched number
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
Do you want to find all numbers matching the criteria?
 
Upvote 0
I am not sure if I understood you correctly but it sounds like the VLOOKUP formula should do the job
 
Upvote 0
I want to find only a specified number within a range like range

2101200 to 2101299

And Find a number within these ranges if i want to find 2101210 or 2101297, both lies within said range.
 
Upvote 0
would this information help?

<html><head><title>Excel Jeanie HTML</title></head><body>

<!-- ######### Start Created Html Code To Copy ########## -->

Excel Workbook
ABCDEF
1StartEndValue
221001002100199A2100105A
321301002130199B2130157B
Sheet2




<!-- ######### End Created Html Code To Copy ########## -->

</body></html>
 
Upvote 0
Thanks Sir for your reply

But I want a use form to search a number within a range let me explain you if i have got 10 sheets in a workbook having contained different ranges and I want to find a number which lies within a range and, search result through user form goes to that range which has searched number meaing to say that goes to that cell which contain searched number within its start or end range.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Best approach (VBA) to search through a sheet for all matches to a selected range (ie. multiple cells)?
Replies
2
Views
68
radiocam
R
K
  • Question
VBA deleterows
Replies
6
Views
116
Peter_SSs
Peter_SSs
T
  • Question
Multiple filters on filtered list
Replies
1
Views
214
Cubist
Cubist
P
  • Solved
Finding Colum Name
Replies
7
Views
209
projectgregory
P
A
  • Question
Creating A Numbered Input Box of Values Found From Finding Files In A Folder
Replies
0
Views
85
Ark68
A

Forum statistics

Threads
1,214,918
Messages
6,122,257
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top