close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()