Posted by Keith on January 10, 2002 11:43 AM
I imported a query in excel and it works fine. I named the imported data: DATA4. Then I used the =VLOOKUP formula to lookup corrisponding data when a user types in the id number. The name, email address, and phone are displayed in the cells with the =VLOOKUP formula. I was wondering if there is a way I could maually type in and update the data in one of these cells without erasing the =VLOOKUP formula. Thank You for all your help so far Mark.