I've consulted "Help" but unfortunately it's not clear enough for amateurs.
Maybe someone can direct me to a MS webpage that covers this type of thing
real well because I really struggle with these type of formulas. I don't
post my question here until I've tried for some time to do it myself. Okay,
here's the formula I need:

=IF(C2="Yes","",(VLOOKUP(B2,NIRAV,2))) This formula is not complete for
what I want and is partially incorrect. Note: "NIRAV" is a named range,
which is in Col. A of another worksheet (same workbook). It is a column of
numbers. I want the formula in my first worksheet to look at the number in
B2 and find the corresponding number in the NIRAV range and then give me the
date that is in the same row in Col. B. However, if there's no date, I want
the formula to return "Not Scheduled".

I can't thank you enough! Connie