I have been struggling with this question for the last few weeks, and
finally have resorted to asking for help. I am trying to get a search
field so that when i type out an item in a list that the resulting
title respond as illustrated in the image below. If anyone can offer
some assistance, it would be greatly appreciated.

http://www.redlightcreations.com/shared/excelsearch.JPG


--
Kenrossco
------------------------------------------------------------------------
Kenrossco's Profile: http://www.excelforum.com/member.php...o&userid=29484
View this thread: http://www.excelforum.com/showthread...hreadid=491873

Anyone at all?


--
Kenrossco
------------------------------------------------------------------------
Kenrossco's Profile: http://www.excelforum.com/member.php...o&userid=29484
View this thread: http://www.excelforum.com/showthread...hreadid=491873

Lots of people won't take the time to open attachments or go off to other sites
to look at pictures.

You could have posted your question in plain text and I'm sure you would have
gotten a quicker answer.

=INDEX(A11,MIN(IF(A299=G2,COLUMN(A299))))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

Kenrossco wrote:
>
> I have been struggling with this question for the last few weeks, and
> finally have resorted to asking for help. I am trying to get a search
> field so that when i type out an item in a list that the resulting
> title respond as illustrated in the image below. If anyone can offer
> some assistance, it would be greatly appreciated.
>
> http://www.redlightcreations.com/shared/excelsearch.JPG
>
> --
> Kenrossco
> ------------------------------------------------------------------------
> Kenrossco's Profile: http://www.excelforum.com/member.php...o&userid=29484
> View this thread: http://www.excelforum.com/showthread...hreadid=491873

--

Dave Peterson

Hey Dave,

Would like to thank you for your response. I can understand one
hesitance to open an outgoing link. I will definately give this a tr
and see how it goes. Thank you again. I truely appreciate the time yo
have taken to help me answer my question

--
Kenrossc
-----------------------------------------------------------------------
Kenrossco's Profile: http://www.excelforum.com/member.php...fo&userid=2948
View this thread: http://www.excelforum.com/showthread.php?threadid=49187

Thank you Dave again for your help.

Finally I am able to get this spreadsheet to work. Thank you again!


--
Kenrossco
------------------------------------------------------------------------
Kenrossco's Profile: http://www.excelforum.com/member.php...o&userid=29484
View this thread: http://www.excelforum.com/showthread...hreadid=491873

Glad you got it working.

Just some info:

You're using excelforum to access this newsgroup. Most people who connect
directly to the newsgroup (avoiding the web based interfaces like excelforum)
like to see plain text messages.

Excelforum provides a way to attach files, but lots of people who don't use
excelforum won't see them--or take the time to go to excelforum to see them.



Kenrossco wrote:
>
> Thank you Dave again for your help.
>
> Finally I am able to get this spreadsheet to work. Thank you again!
>
> --
> Kenrossco
> ------------------------------------------------------------------------
> Kenrossco's Profile: http://www.excelforum.com/member.php...o&userid=29484
> View this thread: http://www.excelforum.com/showthread...hreadid=491873

--

Dave Peterson