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

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 DS.

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

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

Originally Posted by Bill Manville

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

Wow! Thanks!

Best regards,
wally