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?
..........
Yes--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531757
That was cruel!
Try Vlookup and post back if you still have a problem:
contextures.com/xlFunctions02.html--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531757
- Feb 22 Thu 2007 20:35
How to make other cells give a specific value when entered into a
close
全站熱搜
留言列表
發表留言