Hi all,
I am new to this forum, so a bit unsure how this would work. Anyway, I have a situation where in a workbook, in one sheet, I have a list of random numbers, sorted ascending (please see example sheet attached, "data" worksheet), and in another sheet ("ranges") I have a from / to set of ranges of numbers. I need to find if a particular number in the "data" worksheet is found in any of the from/to ranges in the "ranges" worksheet. If the number is found in a range, then I'd like to know the row number of that range, input in column B of the "data" worksheet against that number. If it is not found in any of the from/to ranges, then nothing should be displayed. Any help, even if it involves VBA, would be very appreciated.
Many thanks.
I am new to this forum, so a bit unsure how this would work. Anyway, I have a situation where in a workbook, in one sheet, I have a list of random numbers, sorted ascending (please see example sheet attached, "data" worksheet), and in another sheet ("ranges") I have a from / to set of ranges of numbers. I need to find if a particular number in the "data" worksheet is found in any of the from/to ranges in the "ranges" worksheet. If the number is found in a range, then I'd like to know the row number of that range, input in column B of the "data" worksheet against that number. If it is not found in any of the from/to ranges, then nothing should be displayed. Any help, even if it involves VBA, would be very appreciated.
Many thanks.
Attachments
Last edited: