Bloomberg currency/date question

[kellyfirth]

I need Bloomberg to import a historical price into excel for a specific date and currency. So far, I've got it to find the date I need using the below formula:

=(BDH(A2,"PX LAST","12/17/2014","12/17/2014"))

(A2 contains the ISIN code)

But I need it to pick up a specific currency too. For example's sake, I want to use the above formula but pick up the AUD price.

Is this possible? Let me know if any more information is needed!

 

[oldbrewer]

	C7	$	£	EURO
	02/01/2014	3.15	4.47	5.79
	03/01/2014	3.14	4.48	5.82
	04/01/2014	3.13	4.49	5.85
	05/01/2014	3.12	4.507	5.88
	06/01/2014	3.11	4.51	5.91
				F23
	if you want the £ price for	05/01/2014
	4.507
	formula is
	=OFFSET($C$7,MATCH($F$23,$C$8:$C$12,0),MATCH("£",$D$7:$F$7,0))

<colgroup><col><col><col span="2"><col><col span="5"></colgroup><tbody>
</tbody>

 

[kellyfirth]

I need this to pick up the price from Bloomberg, like using the formula I pasted above. I don't already have the data to hand, that's the problem. I need it to pick up specific currencies.