Hi,

You could use a VLOOKUP along the lines of. sort your data in numerical order

If your data is in range A2:B500
Enter this in B1

=VLOOKUP(A1,A2:B500,2,0)

Type the old number that you looking for in A1 and your number will be
returned in B1.

Hope this helps,

Gav.




"JCM" wrote:

I need to create a form in excel that has a field to enter a number, press
some type of a function or button and have excel return a value of another
number. My numbers would be in column A and in column B.

Example:

A B
12345 5786
9876455 12890

So in the form a person would type 12345 in the first box and press or click
on a button and excel would return the value of 5786 in a 2nd box on the
form. I have a large list of numbers in column A and in Column B. So if the
numbr someone was looking for is in coumn A the form would always return the
value of the same row but in column B. There may be several people using the
form at the same time and they would only have inquiry capabilities.
Basically, I am trying to convert an old number into a new number just based
on what is in the spreadsheet. If excel isnt the right program, any
suggestions would be helpful.