Formula Help between 2 worksheets

[2Fishie]

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?

 

[Max]

Here's 2 ways to look it up - vlookup or index/match

In Sheet2,

Place in B2:
=IF(ISNA(MATCH(A2,Sheet1!A:A,0)),"",VLOOKUP(A2,Sheet1!A:B,2,0))
Copy down as far as required

Alternatively, you could use in B2:
=IF(ISNA(MATCH(A2,Sheet1!A:A,0)),"",INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)))
Copy down as far as required

 

[T. Valko]

Try this:

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