Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a find form in a worksheet | Excel Discussion (Misc queries) | |||
Find comment replace cell value | Excel Discussion (Misc queries) | |||
Excel - create button to replace cell content with cell value | Excel Worksheet Functions | |||
find and replace cell reference to a new worksheet | Excel Worksheet Functions | |||
How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) |