You want Vlookup, but you also need to be able to calculate the column
number.

For example, if you wanted to convert USD, you would use something like:

=vlookup(cell,table,3,false)

because USD is in column 3. Now we just need a way to calculate the column
number. Match will do that. So try:

=vlookup(cell1,A:F,match(cell2,A1:F1,0),false)

Adjust the ranges to suit.

Regards,
Fred.

"alex" wrote in message
...
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?