View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EoinL EoinL is offline
external usenet poster
 
Posts: 1
Default Vlookup with more than 1 criteria

Dog brown 25
Dog Grey 28
Cat Blue 30
Rabbit Brown 12
Dog grey 18

Can the vlookup function be used to lookup more than one value in a row and
return a single corresponding value?

In the example below I want to return the value 25. But if I lookup "dog",
there's two and if I look up "brown" there's also two so I need to lookup dog
and brown together?