Forum Discussion
Help on an IFS statement please
Integrity_Drywall In the attached i created a table with your model names and sq.ft. info and then to the right I have a drop down to select a model and then in the next cell I use VLOOKUP to lookup the sq.ft. for the model you selected. I hope it helps you learn/understand how to use a LOOKUP. There are also innumerous resources on the web. I highly recommend this method as it makes your life much easier. The formula is much smaller and easier to understand (once you understand LOOKUP) and you can easily update/change the information in the table and not have to search every formula.
Integrity_Drywall In the attached i created a table with your model names and sq.ft. info and then to the right I have a drop down to select a model and then in the next cell I use VLOOKUP to lookup the sq.ft. for the model you selected. I hope it helps you learn/understand how to use a LOOKUP. There are also innumerous resources on the web. I highly recommend this method as it makes your life much easier. The formula is much smaller and easier to understand (once you understand LOOKUP) and you can easily update/change the information in the table and not have to search every formula.
