Search function

[scareypirate]

Hi peeps. I really need some help here and know this is the place to ask.

What I need is as follows:

I have a grid of car registration numbers. I need the ability to have a search box and enter a car registration number. If a match is found I need it to give me the location of that reg number.

Example:

Search 'WJ05ASP' would return 'A4' as WJ05ASP is located in the column A Row 4.

I have searched here but can't seem to find anyone asking this.

Thanks anyone that can help me here. And if you require a excel attach example to play with then I will provide one.

All the best

 

[T. Valko]

Hmmm. Can I forward you might sheet again? Only I have tweaked it and not yet got rid of the colour but my P1 results in O1. Not sure why if it's working your side. Must be me

Yeah, post the link.

 

[scareypirate]

Yeah, post the link.

Cheers mate really appreciated:

http://www.mypersonalpage.talktalk.net/images/excel/Vehicle location.xls

 

[scareypirate]

weird. I just deleted the contents of P1 and entered a new registration and it worked.......

You are brilliant. I can't thank you enough for your time and effort. You're an asset to this site mate.

God bless you

 

[T. Valko]

Cheers mate really appreciated:

http://www.mypersonalpage.talktalk.net/images/excel/Vehicle location.xls

If you unhide column O you'll see that you have an entry in cell O1 that is the same entry as cell P1.

 

[scareypirate]

If you unhide column O you'll see that you have an entry in cell O1 that is the same entry as cell P1.

LOL I am such a muppet..... Thanks mate you are a starrrrrrr!!!!!!!!!!!!!

 

[T. Valko]

LOL I am such a muppet..... Thanks mate you are a starrrrrrr!!!!!!!!!!!!!

You're welcome. Thanks for the feedback!