| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make other cells give a specific value when entered into a
I am trying to make a couple cells in a row display values based on entering
a third value in another cell. Can you reference off of a seperate worksheet or enter a table of values that will return values that correspond to the third cells value? Example , If i enter 300 in third cell, I want cell 1 to read .99876 and cell 2 to read .9987. If i enter 301 i want the corresponding values to 301 in cell 1 and 2 . Can this be done with excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make other cells give a specific value when entered into a
.......... Yes -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531757 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make other cells give a specific value when entered into a
That was cruel! Try Vlookup and post back if you still have a problem: http://contextures.com/xlFunctions02.html -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531757 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
| How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
Linear Mode
