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?