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