I have a sheet that has data in two columns, the first is the key, the second
the data.

I'm trying to create a function that will take the key and return the data.

Here are my questions:

1. I have heard that Excel has some databse type ability. If this is so, is
there a qay I can just write a query to look at this data?

2. Failing that, I'd need to be able to find the end of the data, search it
and return the item in the column next to the key. How would I do this?

Any and all help appreciated.

Mike

Look at the VLOOKUP worksheet function Help topic.

=VLOOKUP(key_location,data_range,2,FALSE)

--

Vasant

"ThisShouldBeEasy" wrote in
message ...
I have a sheet that has data in two columns, the first is the key, the
second
the data.

I'm trying to create a function that will take the key and return the
data.

Here are my questions:

1. I have heard that Excel has some databse type ability. If this is so,
is
there a qay I can just write a query to look at this data?

2. Failing that, I'd need to be able to find the end of the data, search
it
and return the item in the column next to the key. How would I do this?

Any and all help appreciated.

Mike