When to apply lookup on concatenate table

[#1]

I am wondering at what point should I apply lookup formula on a concatenated table?

I have two tables, one containing call information, one containing email information.

I want to apply a lookup on the phone number and the email address so that a name appears in one column. How would I go about doing this? Do I need to concatenate the tables and then apply the lookup or apply the look up separately to both tables and then concatenate?

Thanks,

Drew

[tresesco]

May be like attached sample.

[#3]

Hi tressco

Unfortunately this isn't quite what I am looking for:

I want to be able to create a list box with the names and then be able to see the number of calls and emails that person has sent/received

Thanks

[tresesco]

Create a chart with:

dimension: Name

Exp1: Count(callto)

Exp2: Count(callfrom)

?

[miikkaqlick]

Here. Number of calls by name in chart.

Br,

Miikka

Climber Finland