Excel INDIRECT combining text string and Cell-content

[kaaare]

banana_order_12.xls
[tt]+----------------+-------------+
| | A | B |
+-+--------------+-------------+
|1| Type: | 501 |
+-+--------------+-------------+
|2| Price: | =see_below |
+-+--------------+-------------+
[/tt]

Here i try to get banana type 501's price from standardvalues.xls,
when making standardvalues.xls i gave the cells with prices the name
TypeNNN where NNN corresponds to the banana type (see xls below).

='[standardvalues.xls]Bananas'!INDIRECT("Type" & B1)


standardvalues.xls
[tt]+----------------+-------------+
| | A | B |
+-+--------------+-------------+
|1| Type 501 | 12,40 | <- B1's cellname is Type501, since just 501 is an
+-+--------------+-------------+ illegal cellname.
|2| Type 502 | 9,90 | <- B2's cellname is Type502.
+-+--------------+-------------+
[/tt]

Can you correct my syntax, or give advice on another way to do this?
Forgive and let me know if i'm unclear about anything, and i'll do my best at explaining it. Thanks

 

[SkipVought]

Hi,

[tt]
=indirect("'[standardvalues.xls]Bananas'!Type"&B1)

Skip,
[sub]
[red][/red]
[/sub]

 

[kaaare]

Thanks, greatly appreciated!