Excel Search Inquiry

K

Kenrossco

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
 
D

Dave Peterson

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(A1:D1,MIN(IF(A2:D99=G2,COLUMN(A2:D99))))

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.
 
K

Kenrossco

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
 
K

Kenrossco

Thank you Dave again for your help.

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

Dave Peterson

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.
 
Top