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?

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?

Maybe have a third column in your table to contain currency type, and
return this to your main data area along with the pay rate.

Hope this helps.

Pete

On Aug 30, 10:28 am, 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?