using hlookup & vlookup as part of a formula

[sukai]

Hi,
can someone help me with the following?
I want to use a formula that will lookup the exchange rate for me for a currency in a month . What I actually want is the cell reference. Here is an example of what I am trying to do:

=AUD!C3/EX_Rates!G15+CAD!C3/EX_Rates!C15+CHF!C3/EX_Rates!F15+EUR!C4/EX_Rates!I15+USD!C6/EX_Rates!B15

CURRENCY EXCHANGE RATEs

US$ C$ DKr SKr CHF A$ NZ$ EURO HK$ NKR SGD
Mar-11 1.6138 1.5776 8.5795 10.2375 1.4810 1.5978 2.1795 1.1505 12.57528 9.02918 2.04585
Apr-11 1.6394 1.5679 8.4434 10.1191 1.4704 1.5427 2.0720 1.1322 12.73960 8.82100 2.0390
May-11 1.6321 1.5831 8.5202 10.2405 1.4245 1.5292 2.0455 1.1427 12.68240 8.96390 2.0203
Jun-11 1.6181 1.585875 8.40995 10.277275 1.360725 1.5272 1.988325 1.1277 12.5978 8.83645 1.997875
Jul-11 1.61886 1.55 8.42888 10.31282 1.32952 1.50042 1.90854 1.32952 12.6087 8.80184 1.96838
Aug-11 1.6365 1.6146 8.5267 10.5184 1.2816 1.5682 1.9678 1.1447 12.76220 8.95750 1.9818
Sep-11 1.5782 1.5865 8.5603 10.4909 1.3728 1.5479 1.9518 1.1497 12.29710 8.88390 1.9781

 

[Andrew Poulsom]

I know where they are in your table. Where are the date and currency that you want to look up in your table?

 

[sukai]

B4:l34

 

[Andrew Poulsom]

That's where your table is, not where the date and currency are that you want to look up in your table?.