Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If I enter a value (A) I want excel to tell me a value for (A)...
Hi, I want to create an excel spreadsheet to do the following: Basically I want to 'size' a component by entering it's 'Full load current; (in Amps) in one cell and then in another cell I want it to display what component I should use e.g. If I enter 1.4Am I want excel to tell me I need a 3RV1011-1BA10. How can I achieve this? I realise that I will have to enter all the component ranges in somehow but I don't know where to start. -- Ste1978 ------------------------------------------------------------------------ Ste1978's Profile: http://www.excelforum.com/member.php...o&userid=32398 View this thread: http://www.excelforum.com/showthread...hreadid=521647 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) |