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


Gord Dibben MS Excel MVP


On Wed, 3 Sep 2008 13:32:00 -0700, 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

On Sep 3, 6:59 pm, Mandy wrote:
I did look it up, but it only lets me add one at a time, I need it to include
each of them.



"Don Guillett" wrote:
Lookup LOOKUP in the help index

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mandy" wrote in message
...
I am creating a tracker for my work time and I am getting fusterated at
creating this formula, any help would be apreciated:

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

These are the words I am working with, I need it to work like this:

if B2="UPAID" (is choosen from the list)THEN RETURN "U"in B3, IF B2="PTO",
THEN RETURN "P" in B3 .....ECT... This has to work all- Hide quoted text -

- Show quoted text -