#Xlfn formulas excel for mac 2011 how to
WALNUT",VLOOKUP ( B19,ProductList!$A:$J,6,FALSE ),IF (OR ( $F$3="CLASSIC-FLAT SAWN WALNUT", $F$3="CLASSIC-MAHOGANY", $F$3="CLASSIC-OAK" ),VLOOKUP ( B19,ProductList!$A:$J,7,FALSE ),IF (OR ($F$3="SPECIALTY-DOUGįIR", $F$3="SPECIALTY-LAMINATE", $F$3="SPECIALTY-RIFT WALNUT", $F$3="SPECIALTY-FLAT SAWN TEAK", $F$3="SPECIALTY-RIFT TEAK", $F$3="SPECIALTY-WENGE" ),VLOOKUP ( B19,ProductList!$A:$J,8,FALSE ),IF (OR ( $F$3="PREMIUM-BAMBOO", $F$3="PREMIUM-ZEBRAWOOD" ),VLOOKUP (B19,ProductList!$A:$J,9,FALSE ),IF (OR ( $F$3="RECLAIMED-BARNĭOOR", $F$3="RECLAIMED-WINE BARREL" ),VLOOKUP ( B19,ProductList!$A:$J,10,FALSE ),"" ) ) ) ) ) ) ) ),"")Īny insight on how to resolve these is greatly appreciated.
Recently, a coworker created an Excel template to do this more efficiently, but I am encountering the following conflicts that make it unusable: We are an all-PC shop except for my Mac rig which I need for on- and off-site work.
0 kommentar(er)
