=LOOKUP(A7,{"0055622","0055625"}),{"This worked 1","This worked 2"})


--
Regards,
Tom Ogilvy

"Computer Lady" wrote in message
. ..
I am currently utilizing the following formula:

=LOOKUP(A7,{'0055622,'0055625}),{"This worked 1","This worked 2"})

However, when I put it into Excel, it is dropping the leading zeros on my
test numbers. It looks like the following:

=LOOKUP(A7,{'55622,'55625}),{"Obsolete Test","New Version of This Test
Exists"})

I really need this formula to retain the zeros. Any ideas on how I would
do
this?

Thanks!