Create a search engine in excel to display an item and corresponding characteristics

[rotterdam010]

Hello everybody,

I would like to know how I can build a search engine. I have attached a file with an idea about how I would like it. What I would like to have is a sheet with a search button. If the correct number is putted in this file the corresponding data should appear in the same sheet. I do not know how to make this at all!!
This is just a small file but if i know how to build it, it would concern a much bigger file and maybe even some graphs (if that is possible)

Can someone help me?

thnx!

[Spencer101]

Hi, Put the below formulas in the cells mentioned:

C9 - =VLOOKUP($C$5,data!$A$2:$D$13,2,FALSE)
D9 - =VLOOKUP($C$5,data!$A$2:$D$13,3,FALSE)
E9 - =VLOOKUP($C$5,data!$A$2:$D$13,4,FALSE)

The results will change automatically when you change the number in C5.

[rotterdam010]

Thank you spencer101 for the quick response, it took me a while because I had to translate the formula to another language.. (hope to change that also one day)
It worked, this is what i wanted. Is it also maybe possible to show some sort of a graph. So for instance in maintenance, when a car has broken down, can you show the history of earlier defects this car had? like: 4 times a broken engine, 2 times a oil leak, etc. (maybe a bit of a weird example....)

thank you!

[Spencer101]

Hi,

Yes it would be possible to graph details like that. But to be able to provide help on that we would need to see an example of your actual workbook so we could see the layout and how data is used and stored.

S.

[Ghozi Alkatiri]

write at C9 (sheet search engine)
=OFFSET(data!$A$1,MATCH($C$5,data!$A$2:$A$13,0),COLUMN(A$1))
copy to right

[rotterdam010]

Thank you all, I will make an example of a workbook.

[mubarakal]

Bro i del c5 then show #n/a help me sir.

[Ghozi Alkatiri]

offcourse, all result depend on value atC5 (OFFSET(data!$A$1,MATCH($C$5,data!$A$2:$A$13,0),COLUMN(A$1))
so if C5 was blank then show #N/A

[arlu1201]

mubarakal,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.