Formula Help between 2 worksheets

2

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?
 
M

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
 
Top