Forum Discussion

IntegralBuilders's avatar
IntegralBuilders
Copper Contributor
May 10, 2023

Is there a problem with this formula?

=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? 

Formulas and Functions

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 10, 2023

    IntegralBuilders 

    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))

Resources