[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 101
  • Last Modified:

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
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
  • 2
1 Solution
 
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
 
nutschCommented:
You can use iferror

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

Thomas
0
 
Matt PinkstonAuthor Commented:
Thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now