- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Lookup - text and numbers

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?

- RE: Lookup - text and numbers posted by ShaneDevenshire on Tue, 1 Jul 2008