This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 60%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
The instruction IF(AND(D36="DC",A11="WY25",D38=”INTSUM”),FWDD,NONE) gives an error (NAME at INTSUM).
Bold only here to point to the location of the error.
INTSUM is a text from a dropdown list. This dropdown list also has the text SCM which also results with the error.
FWDD and NONE are named locations. These aren't the problem.
The dropdown list doesn't appear to be an issue either because "WY25" is also from a dropdown list all be it from a different list.
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
For whatever reason, you first two strings are enclosed in dumb quotes (" ") while the third is enclosed in smart quotes which I cannot reproduce in this message but which appear in Excel as small superscript commas. Replacing them with dumb quotes solved the problem.
yes - figured it out, I was using word to write the instructions and when you run double quotations there different. Problem solved. Thanks.