Forum Discussion
Solved
Formula Help - Square footage conversion
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.
- Insert $ before the row number, like this:
F$2
4 Replies
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
- Insert $ before the row number, like this:
F$2Thank you! I forgot about those silly $ signs. This has resolved my issue.
- You’re welcome.
