Solved

Lookup From one tab to another

Posted on 2014-03-26
5
88 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
  • 2
  • 2
5 Comments
 
LVL 39

Expert Comment

by:nutsch
Comment Utility
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
Comment Utility
or by individual cell copied down the column as required;

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

Author Comment

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

Accepted Solution

by:
nutsch earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

772 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now