Vlookup and Delete Row Beneath

[steviegee]

Hi all



is it possible to use vlookup to find the selected cell and then delete data under the selected cell?? is this possible, and if so what would the formula look like, for example i'll say cell D4 is the cell that v lookup will find.


Many thanks
steviegee

[steviegee]

Hi


I am trying to delete data from under searched cell that vlookup finds, i am struggling to think of a formula, am i wasting time, or can this be done, any advice would be greatly appreciated.
Thanks
steviegee

[VBA Noob]

Think you will need code.

Try the find method and offset function

http://www.ozgrid.com/VBA/find-method.htm

http://www.j-walk.com/ss/excel/tips/tip20.htm

VBA Noob

[VBA Noob]

steviegee,

Please read forum rules below. Your duplicate posts have being merged

VBA Noob

[steviegee]

HI all,




is it possible to get vlookup to search for the selected cell, then delete cell data underneath the cell? if this is possible what would the formula look like?
any advice would be greatly appreciated.



steviegee

[steviegee]

Hi,




Thank you for the explanation, i appologise for double possible treble posting, It won't happen again.

Thanks for your time and help,


steviegee

[TracySW]

In my understanding VLOOKUP just doesn't work that way. The best thing for you to do would be to create a Macro that uses the Edit-Find to pull whatever you want and then goes one row down and then deletes it. You could even make yourself a cell that you could copy the “Find word” from, that way if you wanted to look up another word you could just put it in that cell and then run the same Macro.

Good Luck!