I think you will have to add the currency symbol to your table:

A B C
1 123.45 ‚¬
2 456.78 £

You could then use:

=TEXT(VLOOKUP(D1,A1:C2,2,0),VLOOKUP(D1,A1:C2,3,0)& "#.00")

D1 contained my lookup value

HTH

"JBW" wrote:

I am using VLOOKUP to return an employees pay rate from a simple two column
array.
Some employees are paid in euros and some in pounds, their pay rates reflect
this.

When VLOOKUP returns the value it does not take the format with it, so all
the returned values are in the column format of say £'s.

How can I get the lookup value to return with the correct currency symbol
atached?