On Jun 25, 12:43*pm, joeu2004 wrote:
On Jun 25, 10:13*am, imti m wrote:

Thanks for the reply.
I am getting error. Not sure what I am making mistake.
[....]
=3DIF(AND(INDEX(Sheet1!$C$2:$C$4396,D2)
<=3DB2,B2<=3DINDEX(Sheet1!$D$2:$D$4396,D2)),"Y","N ")

When you copy-and-paste, for some reason equal signs ("=") are turning
into the MIME representation ("=3D").

You should turn off "rich text" (or turn on "plain text") in the
application you use to view these newsgroups.

Alternatively, copy-and-paste into Notepad, then copy from Notepad and
paste into Excel.

FYI, that paragidm (pasting into Notepad first) is often required when
copying form online sources. *So it is a useful procedure to get in
the habit of doing.

If desired, send me your file to dguillett1 @gmail.com