Good Eveing
I have 2 workssheets one is a call logging sheet in excel another is a list of addresses.
What i ideally want to do is enter the site code into the box and it auto fill the telephone number and address into the relevent areas of the sheet automaticly.
Is this possiable?
I have added the shees with some test data for reference.
Many Thanks
Hi,
for simlicity's sake, I've calle the workbooks data.xls and form.xls
In form.xls use a formula like
=VLOOKUP(B4,[data.xls]Sheet1!$A$2:$P$100,9,FALSE)
adjust ranges to suit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks