Forum Discussion
selecting a value based on criteria from three columns
I have a table with 13 columns. Two additional columns need to be calculated based on values in columns 1-13. Specifically as follows: If G2="C" and if B2="Y" and E2="", then the column M1 Value sho...
Douglas_Emmett To avoid a great number of nested IF statements it is indeed best to work with a lookup table. The attached file contains a possible solution using VLOOKUP. If you are on a modern Excel version, however, I would recommend to use XLOOKUP in stead. See if you can apply this method to your real data.
Note that your example data for row 3 has C-Y-BSDF in columns G-B-E. That particular sequence does not exist in the list of conditions. Thus, VLOOKUP returns #N/A.