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!

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

On Thu, 26 Jan 2006 14:13:32 -0600, "Computer
wrote:

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!

That's really odd as I cannot enter a formula at all with anything like your
first array (leading single quote followed by numbers).

So my advice may be useless since I can't duplicate your problem. But you
could enclose the numbers in your first array within double quotes:

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

Or, if this is referencing a table where the lookup values are text (so they
have a leading single quote), you could make that numeric and also, for
appearance, apply a custom format: Format/Cells/Number/Custom type: 0000000


--ron

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505491