Forum Discussion

MeMacz1138's avatar
MeMacz1138
Copper Contributor
Mar 25, 2019
Solved

Index Match problem

I am having a problem with what should be a simple solution.  In the example below, I am trying to create an Index Match formula to look for one value in a table and pull in the Catalog ID.  For exam...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Mar 26, 2019
    To remedy the possible occurrence of duplicates, I suggest this formula in Inventory!A16:
    =IFERROR(INDEX('Original Catalog & Customers'!B$6:B$16,
    SUMPRODUCT(MAX(ROW('Original Catalog & Customers'!C$6:I$16)*
    ('Original Catalog & Customers'!C$6:I$16=B16)))-5),
    "No such")
Twifoo's avatar
Twifoo
Silver Contributor
Mar 26, 2019
To remedy the possible occurrence of duplicates, I suggest this formula in Inventory!A16:
=IFERROR(INDEX('Original Catalog & Customers'!B$6:B$16,
SUMPRODUCT(MAX(ROW('Original Catalog & Customers'!C$6:I$16)*
('Original Catalog & Customers'!C$6:I$16=B16)))-5),
"No such")
MeMacz1138's avatar
MeMacz1138
Copper Contributor
Mar 26, 2019
All formulas worked and provided the same results - thank you so much!
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 26, 2019
    Welcome!

Resources