I have a spreadsheet with two columns, E and F. E is the "from", F is the "to", as in - a range.

So in one row, for example, column E will say 500 and column F will say 510.

The unfortunate user who needs to find the row corresponding to "508" will have to visually identify this row where the From and To columns, when taken as such, constitute the range.

I've looked at VB code for Find method, looked at finding a number WITHIN a range, banged my head against my desk thinking of how to use VLOOKUP to accomplish this, but can't seem to do it =-

I want the user to be able to type "508", and be taken to the row where column E is the lower limit of the range and column F is the upper limit of the range - WITHIN WHICH FALLS THE SEARCHED-FOR ITEGER, "508"

ahhh! please help