That would be a VLOOKUP.

=VLOOKUP(A2,SheetB!A:B,2,0)

Will search for A2 in column A of SheetB and return the corresponding
information in column B. It will return #N/A if values do not match exactly.

Change the A:B to A:rightmost column and ,2, to the number representation fo
the column across. (i.e. - Table A:D, looking at column A returning value
from column D would require ,4,) if you want to return the closest match,
remove the ,0.

"Laura" wrote:

I am trying to figure out how to enter text in one cell in worksheet A and
copy the correlating data from worksheet B where ever it is located, not just
a specific cell. Ex. If I enter an item number in worksheet A, I want to pull
the description from worksheet B to automatically be entered in the cell next
to the item number. Any help will be appreciated!
--
lstewart