checking a number if its in spreadsheet

hey all,

I want to create something that will check to see if a number matches another number in the #Number column.

A simple if statement may be used: if the number matches exactly, return TRUE or if the number does not match, return FALSE.

The only problem is that the spreadsheet cannot be changed. This is more of a style issue. What is the best way to do something like this? An input button? a Dropdown?

please let me knw if clarification is needed.

Also note - the number in the #number column is inputted as text and not number. Again, the spreadsheet cannot be changed so we would have to make due with it.

thanks for responding. I have several questions since I am very new at excel. Where do i find the inputbox and im not sure if i want to use vba find. I want it to return a Found rather than the string of numbers.

it will say FOUND

a popup message would be perfect since we are doing an input box.

anyone? thanks