Forum Discussion
Solved
Excel Formula help!
I am trying to set up an excel workbook that contains multiple sheets. Among them: 1. A sheet that is a master list of products (Column A) and their prices (Column B) 2. 12 identical sheets (one fo...
That could be
=IFERROR(INDEX(Table1[PRICE], MATCH(E3,Table1[PRODUCT],0)), "not defined")if the price is the same for each month
That appears to work! Thanks so much!
singerchickk , you are welcome