Tim has attended:
Excel Advanced course
V-lookup
I am using a v-look up function and have named my range. Every month I add rows into the range (into the middle). The V-lookup does then not pick up the new entries.
I have to rename the range every time for the v-lookup to realise new entries.
Is this always the case? How do I get around this?
Thanks for your help!
RE: 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
RE: V-lookup
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
