create a form and find a value in one cell and replace a value in
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.
|