https://www.lotterypost.com/thread/147067 Lottery Post Forum Topic: excel help en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/147067/733683 https://www.lotterypost.com/thread/147067/733683 Tue, 19 Dec 2006 12:36:43 GMT budward This will work.It will let you type a number in B1 and search Column A for that number. Will return not found if the number isn't in your list.

=IF(ISERROR(MATCH($B$1,A:A,0)), not found ,INDEX(A:A,MATCH($B$1,A:A,0)-1))

=IF(ISERROR(MATCH($B$1,A:A,0)), not found ,INDEX(A:A,MATCH($B$1,A:A,0)))

=IF(ISERROR(MATCH($B$1,A:A,0)), not found ,INDEX(A:A,MATCH($B$1,A:A,0)+1

]]> budward https://www.lotterypost.com/thread/147067/733451 https://www.lotterypost.com/thread/147067/733451 Tue, 19 Dec 2006 00:50:26 GMT phileight lottaloot I'm not sure I uderstand the question. Are you using the find function to do the search?

Are all three digits of each number in one cell? If they are then find by column and value will find each occurance and show what is immediately before and after. if the search box is in the way just drag it to another part of the screen.

if each digit is in a seperate cell this will not work. If you are using some other search method you will need to be more specific.

I believe i... [ More ]

]]> phileight https://www.lotterypost.com/thread/147067 https://www.lotterypost.com/thread/147067 Mon, 18 Dec 2006 20:05:52 GMT lottaloot 621

532

249

I have these numbers located in column A (1:3)

Can anyone help me with a formula that will return my search result (in these case 532) as well as the information immediately above below the location of cell that has my search info

]]> lottaloot