[....][....]In C2:=3DIF(AND(VLOOKUP(A2,Sheet1!
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.
|