CODEWITHSUNDEEP
excelexcel-formula
Tncmk
Tncmk

Reputation: 169

Get the value with multiple criteria

I have two different tables one with Product ID, price and barcode. The other table is with Product ID, parent ID, price and barcode. Product ID is unique and Parent ID is only for those products which have different variables. So, I am trying to find out which formula is the best to get the barcode code for the variable products from it is Parent. Your help is much appreciated.

enter image description here

Upvotes: 0

Views: 64

Answers (1)

ex4
ex4

Reputation: 2448

Find parent with VLOOKUP from table2 and select Barcode-field from that. If that returns N/A, use barcode in Table1 with IFNA.

I don't have Excel in hand right now, so cannot write working forumla right now. But shouldn't be hard.

This solution excepts that if line is a parent it always has a barcode like in your example. If you have to look recursive from "grantparent" entries, it gets more complicated.

Upvotes: 1

Related Questions