Forum Discussion

Amanda Rotger's avatar
Amanda Rotger
Copper Contributor
Mar 10, 2019
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...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Mar 10, 2019
    Insert $ before the row number, like this:
    F$2
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 10, 2019

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