make a box with... or other solution
I have a view sheet1 "View" that gives me de data of sheet2 "List" :
LIST=
"A: number
B: name
C:adress
D: contact
F:issue......"
by inserting in sheet1 cel Q3 "1" it gives me the data of "B1, C1, D1,..."
=Vlookup(Q3;list!A9:AS2008;2;FALSE)
i want to view by the name, and not by the number.
so, going to "list" sheet, putting a shearch box (always visible) to shearch
EX: "paul", it will give me the number for me to put in sheet "view" in "Q3"
by pressing a button link " VIEW DETAILS " ( go to sheet "view cel Q3").
ps: that´s a very big list whit almost 60 columns each one with diferent data
solutions are welcome.
i dont know if I'm clear
thank's in advance
Paulo Alex - Santa Maria - Azores Island
|