Dear helper.

How would I do this?

I have 2 tables.

TABLE 1,
Service Type A Service Type B Service
Type C
boxtype |zoneA|zoneB|zoneC |zoneA|zoneB|zoneC |zoneA|zoneB|zoneC
A 10 20 30 15 25 35
20 30 70


TABLE 2,

Province | Zone
ABC A
ABD B
ABE A
ABF C

Now my report is.

I can get the boxtype, Service Type, Province.

Example

if I get,
A (boxsize) | Service Type (B) | ABF (province - zone C)

if all the criteria are match, then show the numbers (70)

How do I create functions for this, pleae help.

Thx,


--
Nav
------------------------------------------------------------------------
Nav's Profile: http://www.excelforum.com/member.php...o&userid=35831
View this thread: http://www.excelforum.com/showthread...hreadid=556118