Concatenating two lookups

[Jomercat]

Hi all,

Hope anybody can help.

I am trying to concatenate two lookups within one field, but for some reason it only populates the first lookup.

Here is the code.

=LOOKUP(DATA1,STATE="IL")+ LOOKUP(DATA2,STATE="CA")

It is only populating the results of the first lookup.

Any help would be appreciated.

Thanks.

Jose.

 

[janhes]

LOOKUP, SEARCHUP, SEARCHDOWN are odd functions - you only seem to be able to do one per rule.
Do lookup 1 in output card 1, lookup 2 in output card 2 and merge them in output card 3.

 

[BocaBurger]

You could do them in one card, but different rules. Third rule would do the concatination.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!