Smart search to enter data

Hello everyone.
First of all it is an honor to belong to this great Excel forum. A few days ago I registered and the truth is that I was very surprised.
I see that incredible things can be achieved that I had no idea could be done.

This is my first publication and it is to ask for your help.

I have to work in construction and I am constantly accessing a book (database) to enter these in other books.

1.jpg
Database Example: With information in A, B, C and D
Someone can help me create an intelligent search engine that is linked to my database and works with keywords; where throw all the possibilities and allow which to use; and as that returns me the values according to the following criteria in rows: A = A, B = B, C = C, D = Q
2.jpg
Example of how you should insert the information.

In the database I only added a few as an example; However, I have many coincidences so I would like to throw all the possibilities and allow me to choose which one to use; and then proceed with the data.

I enclose the sample files. Any help will be greatly appreciated. I say goodbye and thank you in advance.

Originally Posted by Romero14

Database Example: With information in A, B, C and D
Someone can help me create an intelligent search engine that is linked to my database
and works with keywords; where throw all the possibilities and allow which to use;
and as that returns me the values according to the following criteria in rows: A = A, B = B, C = C, D = Q

A. If the "keywords" you mean is a unique identifier, then maybe you can use vlookup formula.

Something like this when you are in Ejemplo.xlsx :
- type "D001" anywhere in a row of column A
- the text "demolicion a mano de piedra....." appear in the same row but column B
- the text "M3" appear in the same row but column C
- the text "$353.86" appear in the same row but column Q

- type "D057" anywhere in a row of column A
- the text "desmontaje de saude....." appear in the same row but column B
- the text "SAL" appear in the same row but column C
- the text "$125.66" appear in the same row but column Q

and so on.

B. If the "keywords" you mean is anything as long as it match the value which is in BaseDatos.xlsx,
so it's something like this when you are in Ejemplo.xlsx :

- a dialog box appear for the you to type
- you type "mano", which you expect :

IF the words "mano" exist in BaseDatos.xlsx in any row and in any column
Then the first found row which consist "mano" in the BaseDatos.xlsx will be shown in row 8 of ejemplo.xlsx sheet, where
found row value in column A of BaseDatos.xlsx is shown in column A of ejemplo.xlsx row 8
found row value in column B of BaseDatos.xlsx shown in column B of ejemplo.xlsx row 8
found row value in column C of BaseDatos.xlsx shown in column C of ejemplo.xlsx row 8
found row value in column D of BaseDatos.xlsx shown in column Q of ejemplo.xlsx row 8

IF the code doesn't find another row consists "mano" in the BaseDatos.xlsx
then the code finish/stop/

IF the code find another row consists "mano" in the BaseDatos.xlsx
then this row will be shown in the next row of Ejemplo.xlsx sheet (row 9 in this case).

IF the code find another row again consists "mano" in the BaseDatos.xlsx
then this row will be shown in the next row of Ejemplo.xlsx sheet (row 10 in this case).

and so on.
So, the code will loop to each row and columns of BaseDatos.xlsx to check whether the word "mano" exist or not.
If found, then the code will put it into the next available blank row of ejemplo.xlsx sheet.
If not found, the code will stop or give a message box something like "the word you search is not found in BaseDatos.xlsx".

In B, it's like typing any word in Google Search Box, then Google will list the result.
So the question in B, what if a user type "mano" again the next day in Ejemplo.xlsx search dialog box ?
Will the code check first whether the word "mano" already exist or not in Ejemplo.xlsx ?
If found, then the code stop or maybe give a message box "mano already exist here" ?
or the code will continue fill the next blank available row ?
so then there are duplicate rows (consist the same value) in Ejemplo.xlsx.


To be honest, I am sorry as I don't know how to do it if it's B