Look in the help index for VLOOKUP making sure to use the last parameter
since not in order.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
What I would like to do is the following:

Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I
have a database or list. For example, in column a I have a ticker symbol
(MOT), column b the company name (Motorola) and in column c I have a ID #
(0000111).

Now I switch over to spreadsheet B to do some work...what I want to create
is a formula for if I type in the ticker symbol "MOT" in say column a,
column
b and c will automatically fill in the company name and ID # from the
spreadsheet A.

My entries arent in the same order as they are listed in the database...is
there a way to do this? I cant seem to figure it out, hope my wording
isnt
too confusing, thanks!