Mar 10 2019 05:39 AM - edited Mar 10 2019 05:43 AM
Hello all,
I currently have a formula that is working in cell F4. This cell takes the Item description in cell A3, compares it to a data tab, and if those two match it gives me the square footage conversion listed for that specific text multiplied by the quantity shipped (Cell B4).
The issue im having is when i drag the formula down, it wants to read one cell below the cell its designed to read (Cell F3) is there a way i can have every cell in column F read F2 instead of going F3,F4,F5,etc.
I have included my workbook and highlighted the correct cell with the working formula.
Mar 10 2019 06:23 AM
SolutionMar 10 2019 06:53 AM
Thank you! I forgot about those silly $ signs. This has resolved my issue.
Mar 10 2019 07:02 AM
You may simplify your formulas a bit:
=IFERROR(INDEX(Table1,MATCH($A4,Table1[ITEM],0),MATCH($F$2,Table1[#Headers],0)),0)*B4
and
=IFERROR(INDEX(Table1,MATCH($A4,Table1[ITEM],0),MATCH($E$4,Table1[#Headers],0)),0)*B4
Mar 10 2019 06:23 AM
Solution