Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBW JBW is offline
external usenet poster
 
Posts: 42
Default VLOOKUP

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?