Hi, I have a sheet with several rows of five digit numbers, what I would like
to do is highlight the rows and ask excel to look for any number from
39814-39844 (there will only be one) and copy that number into a cell in
another sheet (like a paste link) and then in the next cell of the second
sheet do the same, search the same row for a number within another range of
numbers.

Sam.