Hi,
I have a long list of numbers in Column E. E1:E1250. They go in number order 1-5000, but there are gaps in them. i.e. they start at 1,2,4,11,16,17,21,22,23,26,27,39,40,45,53 etc.
I type in cell B1 a number. Let’s say 4. In Cell C1 I would like to look at the figure in cell C1 (4) and...