May 10 2023 10:33 AM
=IF('Post Frame Input'!C408='Post Frame Input'!D42,(VLOOKUP('Post Frame Input'!C71,'Truss prices'!B9:H26,3,FALSE)),IF(AND('Post Frame Input'!C408='Post Frame Input'!D43,(VLOOKUP('Post Frame Input'!C71,'Truss prices'!B9:H26,6,FALSE))),1000000))
Can someone help me understand why the answer to this formula would be 1000000 when Post Frame Input C408 does equal Post Frame Input D43. Should something be adjusted is this formula to make it work as intended?
May 10 2023 12:07 PM
Does this do what you want?
=IF('Post Frame Input'!C408='Post Frame Input'!D42,VLOOKUP('Post Frame Input'!C71,'Truss prices'!B9:H26,3,FALSE),IF('Post Frame Input'!C408='Post Frame Input'!D43,VLOOKUP('Post Frame Input'!C71,'Truss prices'!B9:H26,6,FALSE),1000000))
May 11 2023 05:44 AM