LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JCM JCM is offline
external usenet poster
 
Posts: 9
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a find form in a worksheet jking80 Excel Discussion (Misc queries) 1 August 11th 06 01:04 AM
Find comment replace cell value [email protected] Excel Discussion (Misc queries) 3 July 5th 06 09:42 PM
Excel - create button to replace cell content with cell value blackmot Excel Worksheet Functions 3 December 7th 05 05:10 PM
find and replace cell reference to a new worksheet Johnny Van Excel Worksheet Functions 0 June 23rd 05 03:41 AM
How can I do a find and replace for a cell that has multiple line. yrat Excel Discussion (Misc queries) 1 April 19th 05 03:48 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"