allocating data specific cells

Posted by neil on January 08, 2002 4:18 AM

i have no excel knowledge so please help

i want to type a ref into a cell and this needs to then input two pieces of info

if i type ref (JS4) into cell B3
i need C3 to show (234.722)
and D3 to show (566.427)

but if ref (JS5) is in cell B3
i need to show( 259.281) in cell c3
and (612.821) in cell d3

any help would be greatly appreciated

neil

Posted by Dank on January 08, 2002 4:46 AM

Did you not read the reply yesterday? If you didn't understand it then you should say, rather than sending the same post again.

Posted by Mudface on January 08, 2002 4:53 AM

As a fairly simple solution try the following: -

In cell C3 enter the formula

=IF(B3="JS4", 234.722, IF(B3="JS5", 566.427,""))

and in D3 enter the following-

=IF(B3="JS4", 259.281, IF(B3="JS5", 612.821,""))

Copy and fill downwards if you want B4 etc to do the same.

Posted by Mark W. on January 08, 2002 7:28 AM

Select cells C3:D3, type or paste the formula,
=VLOOKUP(B3,{"JS4",234.722,566.427;"JS5",259.281,612.821},{2,3},0),
into the formula bar, and press the Control+Shift+Enter
key combination.