Hy there,
i am trying to create an automatic invoice and probably i am making my life much more complicated than i should.
here is my problem... i have these tables (short version) Name Street Place
this i have of a variety of guests. on the invoice of the guest i want to just write the name and it automatically finds the adress and place of the specific guest in my tables.
in my excel file i am writing basically the name of the guest, in the street name i tried it through IF this name, vlookup in this table array. unfortunatly i dont know how i can say that when you find that name use this persons adress, which is below his name... at least i couldnt manage that it shows the correct adress if the person i typed in, just that it shows the name again or the adress of the first person in the list.
hope it is half way clear and someone has an easy solution for me :)