Thank you, Sheeloo, but it was a problem of the NIRAV column not being
sorted, as in Pete's answer. Thank you for taking the time to repsond. I
really do appreciate all the help I get here. Connie

"Sheeloo" wrote:

Your formula is correct and it is NOT an Array Formula...

Most likely the numbers in first column of NIRAV are NOT being treated as
such..

Just to test Copy the cell containing 12639 and past in the cell with that
number in NIRAV... you should get the answer you expect...

"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