finding a number witin a range

[Guest]

i have to place a unique number onto a bag. There is a start number and an
end number. The numbers are in sequence and no numbers are duplicated.
There are approx 5,000 numbers for each job. I need to know if i can find a
number witin the range and display the results.

 

[JulieD]

Hi Paul

VLOOKUP will look for a value and return a related piece of information - so
if your bag numbers are in column A and the results in column B you could
use the following formula

=VLOOKUP(D1,A1:A5001,2,0)
where the number you're looking for is entered in D1.

Hope this helps
Cheers
JulieD

 

[Dave Peterson]

JulieD is returning the 2nd column in her =vlookup() example.

But I think she made a typo--the range was a single column:

Maybe:
=VLOOKUP(D1,A1:B5001,2,0)

And if the OP is looking for more info about the =vlookup() function, Debra
Dalgleish has nice instructions at:
http://www.contextures.com/xlFunctions02.html

 

[JulieD]

Hi Dave

thanks for the correction.

Cheers
JulieD