I am putting together an excel application using vlookup.
I have a list sheet of names that I am searching for related data.
I transfer the data from the list sheet, into a Presentation sheet.
My problem occurs when a name is removed from the list sheet.
I haven't tried adding a name, yet. One hurdle at a time.

Given list sheet names 1,2,3,4,5
I transfer data to a Presentation sheet for names 1,2,3,4,5
Now, remove/delete name 3 from the list sheet
I now have names 1,2,3,4 in the list sheet
However, I am getting a Ref error in row 3 of the Presentation sheet
Row 4 of the Presentation sheet shows data from 3 in the new list sheet
Row 5 of the Presentation sheet shows data from 4 in the new list sheet

I do not understand why the row for the old 3 is still retained in the
Presentation sheet since I am getting the name as well as the data from the
new list sheet.

I hope you can comprehend this. I can sure use a solution.
If you need clarity on anything, I'll do my best to provide it.

Thanks in Advance
William