VLOOKUP formula to text

[Guest]

I'm using a vlookup formula where the user enters a single digit in a cell in
one column, and text shows up in the adjacent cell in the next column.

i.e. typing 2 in column E causes column F to read 'medical leave of absense'

Is there a way to copy the text 'medical leave of absense' in column F into
another file?

this 2nd file is emailed to someone else, I don't want formulas, just text
to show up in this file

 

[Mangus Pyke]

I'm using a vlookup formula where the user enters a single digit in a cell in
one column, and text shows up in the adjacent cell in the next column.

i.e. typing 2 in column E causes column F to read 'medical leave of absense'

Is there a way to copy the text 'medical leave of absense' in column F into
another file?

this 2nd file is emailed to someone else, I don't want formulas, just text
to show up in this file

Before you email it, select the formulas, copy, then:
Edit --> Paste Special
Select Values and click OK

MP