create a form and find a value in one cell and replace a value in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Count Unique Values in a column, with critera, exclude empty cells 11
Last Modified By in a cell by user 3
Find the maximum value in a row or column with text and numbers 2
Return the value from one range that does not exist in another 0
Formula (or code) return the largest number of duplicates in a list. 16
Lookup value that falls between two values in a range and then som 2
Countif with numbers and words 4

Back
Top