Lookup - text and numbers

Giganews Newsgroups
Subject: Lookup - text and numbers
Posted by:  Annette (shed…@hotmail.com)
Date: Tue, 1 Jul 2008

I have a table that formally contained only numbers, now we have one number
with text characters throwing off my formula for return values.  This is the
current formula -

=IF(L19="","",CONCATENATE(LOOKUP(L19,Products!$B$2:$B$111,Products!$G$2:$G$111),"
",LOOKUP(L19,Products!$B$2:$B$111,Products!$D$2:$D$111),"
",LOOKUP(L19,Products!$B$2:$B$111,Products!$E$2:$E$111),"
",LOOKUP(L19,Products!$C$2:$C$111,Products!$F$2:$F$111)))

Is there a way to change this to recognize there could be text and numbers
or do I have to change the tables to be all text?

Replies