Thread
:
Lookup multi criteria
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
oscarcounts
external usenet poster
Posts: 8
Lookup multi criteria
I have two sheets. The second sheet obtains data from the first sheet. The
value (£) depends on three criteria in the same row. ie Code,Cost centre and
Department.
When all three match the value (£) is returned or if not 0.
Reply With Quote
oscarcounts
View Public Profile
Find all posts by oscarcounts