Help needed, search in database and present result.

**Nikorasu** · 10-05-2012, 10:05 AM

Hey there! New member here and in serious need for some help.

Let me first present what we got to work with here:

1. We have quite a large database in one excel page with about 25000 rows, now each row got a unique six digit number in the first column, the rest of the row contains various info separated in the columns.

2. What we would like to do for a start is to have a separate excel page with a "searchable cell" in this cell we would like to input any six digit number and this will start a search in the other document for the row that matches the input number. Now once found we would like to present that row in the searchable page.

Is this possible to achieve in some easy steps

or do we need some extra programming?..

Kind regards!
/Nicholas

**benishiryo** · 10-05-2012, 10:23 AM

hi Nicholas, welcome to the forum. sounds like VLOOKUP can help you. do upload a sample Excel file for us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon

assuming your large database is in A1:G25000 of Sheet1, and the unique 6 digit in the other worksheet is in cell A1, it looks something like:
=VLOOKUP(A1,Sheet1!$A$1:$G$25000,2,0)

this is to look for the unique number in column A & return the 2nd column. just an eg