Forum Discussion
Simple Nested if to bring price of the product
Hi, I need a simple excel formula to price over Three hundred products. So Column 1 would be the model numbers and Column 2 would be the price of the product. In the third column if I enter the ...
That could be
=IFERROR( INDEX(<price per piece column>, MATCH(<model>, <model No column>, 0 ), "not found" )