Ok so here's my dilemma (sorry if this makes no sense at all). I'm trying to create my own searchable database where I can punch in text/information into a cell and have excel do all the work and find the information for me.
I have a table with a few thousand rows and eight columns. What I'm trying to do is have excel take the info that I enter into my "search" cell and find all the rows from my table that contain that info and place them above the table, making it easy to search through so I can find the row of info that I need.
I have tried the LOOKUP function but it would only pull the first two columns... I may be doing something wrong I'm not sure. Any ideas?
Bookmarks