We need to know how the data for providers is arranged - one per worksheet,
or what?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"shaj" wrote in message
...
I am creating a report where the end user will select a provider. Once the
provider is selected, it will look at 1) Provider 2) Month 2) Charges and
go
to the other sheet and select the charges for that provider for that Month
ex:
Provider selected: XYZ
JAN FEB MAR APRIL MAY JUNE
CHARGES: 100 200 300 400 500 600
PAYMENTS: 25 40 20 50 100 200
ADJ: 10 15 20 100 75 50
What I cannot do is lookup at more than one fields.
Thanks again for your help.
Shaji