Try this:

=VLOOKUP(A1,Sheet2!A:B.2,0)

--
Biff
Microsoft Excel MVP


"2Fishie" wrote in message
...
I am trying to get a formula between two worksheets. Basically, if any
value
in column A on worksheet 1 matches a value in column A of worksheet 2,
provide me the value shown in column B in worksheet 2. Any suggestions?
--
Felicia