Lookup From one tab to another

On a worksheet (sheet 1) how do I make column C = column A of sheet2 when sheet1 column B = sheet2 column B
Matt PinkstonAsked:
Who is Participating?
 
nutschCommented:
You can use iferror

=iferror(index(Sheet2!$A$1:$A$1000,match($B2,Sheet2!$B$1:$B$1000,0)),"")

Thomas
0
 
nutschCommented:
in sheet1!B2, use

=index(Sheet2!$A$1:$A$1000,match($B2,Sheet2!$B$1:$B$1000,0))

You're returning the value of Sheet2!$A$1:$A$1000 found at the position where Sheet2!$B$1:$B$1000 matches Sheet1!B2.

Thomas
0
 
CamyCommented:
or by individual cell copied down the column as required;

=IF(B1=Sheet2!B1,Sheet2!A1,"")
0
 
Matt PinkstonAuthor Commented:
How do you get the NA to go away?
0
 
Matt PinkstonAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.