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!
Bookmarks