Hi all

The simplest way to explain what I would like to do is to compare it to
microsoft help function. This where you click on "index" and enter text
in "Type Keyword" which then gives you what you are looking for.

Is there a function to do this?

I basically have 3 columns of data to look up for medical journals

1st column = A - Z (depending on start of journal name)
2nd column = Journal name (e.g. British Journal of Medicine, so column
= B)
3rd column = Status (e.g. peer reviewed, unknown)

I would like to be able to start typing the journal name and then for
it to give full name of a list of possibilities together with the 3rd
column status.

Thanks for any help on this.
S


--
sdfuk
------------------------------------------------------------------------
sdfuk's Profile: http://www.excelforum.com/member.php...o&userid=27587
View this thread: http://www.excelforum.com/showthread...hreadid=471092