HI I have problem with a vlookup in excel 2013. cant make it work IN cell A10 Sheet invoice 1 i have a dropdown menu. refer to column A in sheet Customers . Its the customer names. In the next cells in Sheet Invoice 1 A11 to A14 i need the remaining info for this customer. So i need a vlookup in these cells- A11 is the address, A12 is the post number and town, A13 is the telefone number and finally A14 is the vat number.
Please have a look at below test sheet. Maybe more easy to see there. And upload it with the nessasary changes please-
Thanks in advance
Abjac
Bookmarks