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!