Excel Searchable Database

[Spade_Espada]

1st I am trying to setup a POS System
2nd I want to create a searchable database. What I'm trying to do is create a search box in which text can be entered so that all cell with that text is listed on sheet 1 with the data from the specified column
What I want to be able to do is;
1. Enter info in one cell
2. The data I want returned is not the matched cell but one of the adjoining cells,
I want a simple and efficient way. Please not a Nth number of possibilities, makes sure I'll mess up
My understanding is INDEX/ MATCH is the starting point

 

[Candyman8019]

Assuming your entry cell is A1.

=INDEX(B1:F50,MATCH(A1,B1:B50,0),4)

This formula will match the value you enter in A1, find the match in column B1:B50...and return the value from the 4th column of the original array (B1:F50). By changing the '4' you can have it return for any column in your specified array.

 

[Spade_Espada]

Thank you!!!!