Vlookup book - multi-condition-lookups

[Nina Yang]

Hi All,

I am trying to work out the homework question for "multi-condition-lookups" within the Vlookup book bought from Chandoo.

However, I think there is sth wrong with the defining name part of the criterias. I defined Lawrence as salesperson, West as Region, Feb-13 as month and RapidZoo as Product, however, the formulas isnt working if i use those defined names.

Need help with that~~

Cheers,
Nina

 

[NARAYANK991]

Hi Nina ,

Since others may or may not have the book , I think more details will be needed to help you out.

If you can upload a workbook with data to illustrate your problem , it will make it easy for others to understand your problem.

Narayan