You shouldn't be able to get #N/A if you use X1:X12 as the source list
in a data validation drop-down in B2, unless B2 is empty, so you could
use:

=IF(B2="","O",VLOOKUP(B2,$X$1:$Y$12,2,0))

If you are not using that source list, then you could use this to
avoid the #N/A:

=IF(ISNA(VLOOKUP(B2,$X$1:$Y$12,2,0)),"O",VLOOKUP(B 2,$X$1:$Y$12,2,0))

It does look to me that you are asking for O (upper case o) to be
returned, rather than 0 (zero), but if you want zero to be returned
then replace "O" with 0 in the formula.

Hope this helps.

Pete

On Sep 3, 9:32*pm, Mandy wrote:
Great that worked perfect, how do I make it say O if the return is #N/A



"Pete_UK" wrote:
The idea is that you set up a 2-column table somewhere with your
codes, like this:

PTO * * * * * * * * * * * * * * * *P
Unpaid * * * * * * * * * * * * * * U
Tardy Occurrence * * * * * *T
Exhausted all PTO * * * * EP
Specialized PTO * * * * * *SP
Bereavement * * * * * * * * * *B
Unscheduled PTO * * * * * UP
PTO Manager Override * *MO
Floating Holiday * * * * * * *MO
Jury Duty * * * * * * * * * * * *JD
FMLA * * * * * * * * * * * * * * FM
NML * * * * * * * * * * * * * * * NM

Suppose this occupies X1:Y12. You can have a drop-down in B2 which
uses the list in X1:X12 as the source, and then in B3 you would have
the formula:

=VLOOKUP(B2,$X$1:$Y$12,2,0)

and it will return the appropriate abbreviation.

Hope this helps.

Pete