Solved

Lookup From one tab to another

Posted on 2014-03-26
5
93 Views
Last Modified: 2014-04-11
On a worksheet (sheet 1) how do I make column C = column A of sheet2 when sheet1 column B = sheet2 column B
0
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 39957671
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
 
LVL 8

Expert Comment

by:Camy
ID: 39957677
or by individual cell copied down the column as required;

=IF(B1=Sheet2!B1,Sheet2!A1,"")
0
 

Author Comment

by:Matt Pinkston
ID: 39957703
How do you get the NA to go away?
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39957723
You can use iferror

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

Thomas
0
 

Author Closing Comment

by:Matt Pinkston
ID: 39995456
Thanks
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question