I'm not sure I understand the question.

The formula is the same as the manual suggestion. The only difference is how
you have to specify doublequotes in code (you double them!).

And I used the continuation character (space underscore) so that you don't have
to worry about line breaks in the message (when you copy|paste to the code
window).

ps. Sorry about that extra $ sign.

If f5 = "x"
then show nothing ("")
else if there is no match between F5 and the CWWDate range
then show nothing ("")
else do the index(match())
end if
end if




Tony wrote:

Is there anyway of getting an explanation on how this statement is formatted
to appear as a formula in the worksheet cell:

wsPH.Range("f6:AD6").Formula _
= "=IF(F$5="""",""x"",IF(ISNA(MATCH($F$5,CWWDate,0)) ," _
& """"",INDEX(CWWType,MATCH(F$5,CWWDate,0),1)))"

"Dave Peterson" wrote:

Ps. I didn't test this.

I had no idea what was in F5 and what CWWType and CWWDate were.

Dave Peterson wrote:

Does this formula do what you want if you enter it manually?

=IF(F$5="","x",IF(ISNA(MATCH($F$5,CWWDate,0)),"",
INDEX(CWWType,MATCH(F$5,CWWDate,0),1)))

If yes, then try:

wsPH.Range("f6:AD6").Formula _
= "=IF(F$5="""",""x"",IF(ISNA(MATCH($F$5,CWWDate,0)) ," _
& """"",INDEX(CWWType,MATCH(F$5,CWWDate,0),1)))"

I move the "x" to the front and changed the comparison to equal. It's easier
for my brain to see what's going on.

Tony wrote:

I have the following code that gives me a #N/A for some cells. I want to
change it to "" using an error statement such as =IF(ISNA(.... Can anyone
assist me here.

wsPh.Range("f6:AD6").Formula = "=IF(f$5<"""",INDEX(CWWType,
MATCH(f$5,CWWDate,0),1),""x"")"

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson