IF(ISNA) formula based on content of 2 fields

[obionenairobi]

Dear all,

In a report I have 2 sheets:

Sheet 1 : sales figures
Sheet 2 : activity code per address

In sheet 1 I use the below formula to show the activity code behind the address :

=IF(ISNA(MATCH([Address Code];Activities!A:A;0));"";INDEX(Activities!C:C;MATCH([Address Code];Activities!A:A;0)))

Now I have multiple companies in which we have the same customer address.

In the sheet 1 there is also a column with the company reference

Is it possible to extend the formula to look at the company and the address code and then show the correct activity code
In each company the same company can have a different activity code

[NBVC]

Try something like:

Please Login or Register  to view this content.

where Activities B1:B100 contain the Company names to match up with reference on sheet 1 [Company]

Also note: You can't use whole column references with this formula.