Mimic another cell

[afrantz]

Good day, all

In column AI I am doing a vlookup to another sheet. The info that is returned from the vlookup I want to appear in column N but I don't want any formulas in column N (because people may want to past the info in columns B-T down to other rows on the spreadsheet). Is there a way to do this?

Thank you!

 

[Fishboy]

Good day, all

In column AI I am doing a vlookup to another sheet. The info that is returned from the vlookup I want to appear in column N but I don't want any formulas in column N (because people may want to past the info in columns B-T down to other rows on the spreadsheet). Is there a way to do this?

Thank you!

As far as I am aware you would either need a formula in the N column cell or you would need VBA to overwrite whatever a user may paste into N with the correct information / formula.

 

[afrantz]

As far as I am aware you would either need a formula in the N column cell or you would need VBA to overwrite whatever a user may paste into N with the correct information / formula.

Got it. I was kind of thinking that due to the lack of resolutions on Google. Thanks for the response.

 

[Fishboy]

Got it. I was kind of thinking that due to the lack of resolutions on Google. Thanks for the response.

Happy to advise, I'm just sorry it wasn't better news.