Let's say your table is in range A1:F8, column A is your "from" currency and
row 1 is your "to" currency.

The following formula gives you the conversion from EUR to CAD:

=VLOOKUP("EUR",$A$1:$F$8,MATCH("CAD",A1:F1,0),0)

Just substitute "EUR" and "CAD" to the appropriate cell reference in your
second sheet.


"alex" wrote:

Good point Bernard, i'll try to be more specific.

I have something that looks like this.
AED USD BRL CAD EGP
USD 1.2 1.5 2 1 .5
EUR 1.5 3 .75 100 35
MAD etc...
VND
LBP
ZMK
ZAR

This is what i have to use, on another page, i have specific conversions i
need to make and dont want to do this manually every month. So in column A i
have what i need to go from to what i need to go to in column B.
I want to just be able to look those up.
Hopefully that explains it a little better.

Let me know if you can help,

Thanks,

Alex

"Bernard Liengme" wrote:

I think VLOOKUP is the answer but you have not fully explained the problem

Try like this:
In A1:20 I have .....
In the B columns I have....
In the C columns ....

In G1 I have ..... and in H1 I want .....
Then we can be more helpful
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme



"alex" wrote in message
...
how to find the intersection point between a column and a row. Basically,
i
have exchange rates in a column and the rates to which i want to convert
are
in a row. I need to find where the column and row intersect...is there a
way
to do that?