VLOOKUP formula to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

MP
 
Back
Top