V-lookup

Hi Tim

Thank you for your question

If you insert rows into the middle of your named range then in theory the new data should be included in your results. There are several possible things to check here, and it would be easiest if you emailed me a copy of your workbook, i can then investigate and advise.

My email address is

stephen@stl-training.co.uk

Regards

Stephen

Hi Tim,

Did you manage to send your workbook to Stephen?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich