Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for a solution | Excel Worksheet Functions | |||
solution wants | Excel Discussion (Misc queries) | |||
Web Solution | Excel Discussion (Misc queries) | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
Is There A Solution.......? | Excel Programming |