I have a simple VLOOKUP that is working.
Problem is the text source data (sheet1) has strikethrough formatting when appropriate and I'd like to pass that formatting to the result cells of the VLOOKUP (sheet2).
I don't want to have to run a macro to accomplish this. Basically, if I format a cell in sheet1, I'd like to be able to automatically see that value in sheet2 with the strikethrough formatting.
Thanks
Problem is the text source data (sheet1) has strikethrough formatting when appropriate and I'd like to pass that formatting to the result cells of the VLOOKUP (sheet2).
I don't want to have to run a macro to accomplish this. Basically, if I format a cell in sheet1, I'd like to be able to automatically see that value in sheet2 with the strikethrough formatting.
Thanks