View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tim2216 tim2216 is offline
external usenet poster
 
Posts: 6
Default vlookup with match

Here is the code:
=VLOOKUP(S7,A4:A1000,MATCH(T3,B4:B1000,0)+1,FALSE)
I am getting a #ref error.

s7 is the date I am looing for in a column and t3 is text that I am looking
for. What I want is to first look by the date and if the date matches it
looks for the text and if both match it will add the number of times that it
sees those 2 together and return that value. Any ideas on how to get this to
work?