Forum Discussion
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'!C7...
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))
