Forum Discussion
INDEX MATCH #N/A Error
Sorry, I have only just understood what it is you are trying to do. I believe you are trying to find a match in any one of 5 columns and to return the product name. You would need 5 separate MATCH formulas for that and then take the maximum of the 5 row-indices before using INDEX.
Alternatively you could use non-standard formulas such as
= LOOKUP( 1, 1 / MMULT(
SIGN( Table_ProductList[[Product Barcode 1 BOX]:[Product Barcode 5 pallet]] = [@[Product Barcode]] ),
{1;1;1;1;1} ),
Table_ProductList[Item] )
or
= CONCAT(
IF( Table_ProductList[[Product Barcode 1 BOX]:[Product Barcode 5 pallet]] = [Product Barcode],
Table_ProductList[Item], "" ) )
Hi
I try like this (&) and it didn't work
also (:) and not working
only work if I choose one column
is there a way to fix this or there is another formula
please help
Sorry, I have only just understood what it is you are trying to do. I believe you are trying to find a match in any one of 5 columns and to return the product name. You would need 5 separate MATCH formulas for that and then take the maximum of the 5 row-indices before using INDEX.
Alternatively you could use non-standard formulas such as
= LOOKUP( 1, 1 / MMULT(
SIGN( Table_ProductList[[Product Barcode 1 BOX]:[Product Barcode 5 pallet]] = [@[Product Barcode]] ),
{1;1;1;1;1} ),
Table_ProductList[Item] )
or
= CONCAT(
IF( Table_ProductList[[Product Barcode 1 BOX]:[Product Barcode 5 pallet]] = [Product Barcode],
Table_ProductList[Item], "" ) )
Hi
can you please help with the UOM so when i reed a box barcode i can see the unit there or roll and get that data from the header barcode that i have
i try the formula you put and try to change it but i get wrong answer
thanks from the heart
my regards
saeed
Thanks for the help
yes that what I need to do
the lookup formula work for me the other one not working but thats ok. i need only one
Now i try to use the formula for the product barcode UOM (Unit Of Measurement) to the same table, but it gives wrong answer. How i can fix the formula to get only the header name of the specified barcode column.
