yup i did!!! it just stopped for no reason!
let me give some background of X sheet...
the data in X are basically links from a pivot table which i created.
since index/match wasnt able to search from the pivot table earlier,
thats why i made a new sheet called X whereby i did a paste special-
paste links to it.
it was working fine uptil today, when i altered the pivot table's
source data a bit, and refreshed it. even after i changed the data on
the X file to reflect the new and current information, and edited the
formula like you see above, its showing me the #N/A result. why is
that hapenning?