Connie,

it is not an array formula, so no need for CSE.

In omitting the 4th (optional) parameter for VLOOKUP, you are implying
that the lookup table NIRAV is sorted - is this the case? If not then
you should change the formula to:

=IF(D163="Yes","",IF(VLOOKUP(C163,NIRAV,2,0)="","N ot Scheduled",VLOOKUP
(C163,NIRAV,2,0)))

and this forces the function to look for an exact match.

Another area where problems might occur is that the number 12639 might
be a text value in the table and a number in C163 - these need to
match exactly.

Hope ths helps.

Pete

On Nov 12, 7:17*pm, Connie Martin
wrote:
This formula was working and it no longer works:

=IF(D163="Yes","",IF(VLOOKUP(C163,NIRAV,2)="","Not
Scheduled",VLOOKUP(C163,NIRAV,2)))

I believe it's an array formula but whether array or not, it doesn't work.. *

In D163 it says "No". *In C163 is the number 12639. *That number is also in
a named range NIRAV in the first column of that range. *In column 2 of the
range is the date Nov-24-08, but this formula is returning "Not Scheduled". *

Hope that's enough info for someone to please help me out with this. *This
was a great tool until it quit working and I don't know why it quit working. *
I've tried it both ways---as an array formula and without the
CTRL+SHIFT+ENTER. *I get the exact same answers---wrong ones!

Help, please. *Connie