ExcelBanter - How do I use vlookup to return a formula not a result

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I use vlookup to return a formula not a result (https://www.excelbanter.com/excel-worksheet-functions/229846-how-do-i-use-vlookup-return-formula-not-result.html)

G Sedgwick

How do I use vlookup to return a formula not a result

I need to create a lookup to return a copy of a formula if the cell does not
have any result in.

Pecoflyer[_304_]

How do I use vlookup to return a formula not a result

G Sedgwick;333717 Wrote:
I need to create a lookup to return a copy of a formula if the cell does
not
have any result in.

Hi,
I'm afraid you'll need VBA for this

--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93274

All times are GMT +1. The time now is 06:06 AM.