vlookup - 2 files and then delete the second one

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
Hi
I have name, dept, and salary in workbook1 and name, and phone # in workbook2. I used vlookup function to find phone number and put it in workbook1. Everything worked fine. I deleted workbook2 and to my surprised the vlookup function still returning the right phone number? Why is that? did it cache it somewhere? I thought I will lose phone numbers when I delete workbook2!. Thank you so much.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,089,856
Messages
5,410,804
Members
403,330
Latest member
roxmasters2020

This Week's Hot Topics

Top