Selecting a cell depending on the other cell's value, kind of
 

Hi!

I have a table (4x4). It looks something like

A1 = x B1 = 40 C1 = 0.5
A2 = "" B2 = 50 C2 = 0.7
A3 = "" B3 = 60 C3 = 0.9
A4 = 1

A4 gets calculated by looking at which of A1 to A3 that has a "x" in
it. As you can se here, A1 has a "x" in it, thereby A4 gets the value
1.

Now, in D1 I want to do something like

D1 =B&A4*C&A4
in other words,
D1 =B1*C1

This may look stupid here but I need it for something bigger ;):p

The way I'm trying now doesn't work. It gives me a "#Name?"-error
(invalid name (or something like that. I'm running the Swedish version
here ;D)).

If you need any more info, just tell me :)

Thanks!

Best regards,
wally

PS. I wasn't sure where to put this but I'm guessing this is the right
one :D DS.




--
wally_91

Selecting a cell depending on the other cell's value, kind of
 

D1: =INDIRECT("B"&A4)*INDIRECT("C"&A4)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Selecting a cell depending on the other cell's value, kind of
 

Bill Manville;2702213 Wrote:
D1: =INDIRECT("B"&A4)*INDIRECT("C"&A4)
Wow! Thanks!

Best regards,
wally




--
wally_91