I have two sheet of excel one it is sheet for products
with have column like this
| id | name | barcode | description |
|---|---|---|---|
| 1 | opel blazer | 1239423 | europe car |
| 2 | toyota alphard | 9239239112 | japan car |
| 3 | Jeep | 90232321 | Jeep |
this sheet has 1000item and barcode
and other it is sheet for inventory
| id | product_id | barcode | location |
|---|---|---|---|
| 1 | ???? | 9239239112 | 40 |
| 2 | ???? | 90232321 | 20 |
my question is how to set product_id at my inventory from id column from product sheet if we just has information for barcode ? so it will be use filtering and set by barcode
CodePudding user response：
Try below formula-
=INDEX(products!A:A,MATCH(C2,products!C:C,0))
With Microsoft-365 can try-
=XLOOKUP(C2,products!C:C,products!A:A,"")
