ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   make a box with... or other solution (https://www.excelbanter.com/excel-programming/376880-make-box-other-solution.html)

thunderhunter

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




All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com