compare 2 values and return value

I'm looking for a formula which will compare a cell to a column and return a value located on the cell next to it.

Example:

A1. Hello

Search sheet: database

If database!a:a equals A1 then give me the price in the database!b:b colomn.
I'm close but it always returns the first value in database!b:b being B1.

Help!!!

Eric

Hi and welcome to the board

I'm close but it always returns the first value in database!b:b being B1.

What is the "it" you are talking about?
At first glance you need a VLOOKUP function. Best to post a sample sheet