0

I want to lookup sheet 'Product' and grab the Approval status and input it into column B of sheet 'Non Variant'. Obviously matching the correct article number.

Snippet of Non Variant Sheet

Snippet of Product Sheet

  1. Snippet of Non Variant Sheet
  2. Snippet of Product Sheet
user1227124
  • 369
  • 2
  • 3
  • 11
  • 1
    Use INDEX/MATCH. You can't use VLOOKUP since your lookup column (B) is to the right of Approval (A) on the Product sheet. – BigBen Apr 08 '19 at 20:58

1 Answers1

1

Using INDEX(MATCH()) you'll get what you want, just set the range right:

=INDEX(Product!$A$4:$A$8,MATCH($A2,Product!$B$4:$B$8,0))
zipa
  • 27,316
  • 6
  • 40
  • 58