View Single Post
  #1   Report Post  
CMAC
 
Posts: n/a
Default two criteria in a vlookup

how would i do a lookup to return a value if two conditions are met.
instead of =vlookup(a1,d1:h80,2,0) i would like a value to return if a1 and
b1 are matched?
thank you

c