View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paula k paula k is offline
external usenet poster
 
Posts: 2
Default multiple column lookup?

Here is the data I am working with:

LOB C/N #
Corporate Marketing 2
Corporate Marketing Critical 1
Corporate Marketing Non-Critical 1
Corporate Safety 1
Corporate Safety Critical 3
Corporate Security 1
Corporate Security Critical 1

How do I search for a lookup a "Corporate marketing" and "Critical" to
return the number from column 3?

Thanks!!!!