• 462K Members
• 7,580 Online
• 559K Conversations
SOLVED

New Contributor

# 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.

4 Replies
Solution

# Re: Formula Help - Square footage conversion

Insert \$ before the row number, like this:
F\$2

# Re: Formula Help - Square footage conversion

Thank you! I forgot about those silly \$ signs. This has resolved my issue.

# Re: Formula Help - Square footage conversion

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`

# Re: Formula Help - Square footage conversion

You’re welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies