Calculating a conditional value across multiple worksheets

I am trying to create a formula but really struggling! I’ll attempt to describe what I’m trying to do:

  1. Worksheet1 A1 value “Apple”
  2. Look for same value in Worksheet2, range A1:A10 
  3. Where a match is found look up value from Worksheet 2, B1:B10 (e.g. “Fred”)
  4. Where “Fred” matches Worksheet3 A1:A20 return in B1:B20 the number of times the match was found.

Really sorry if this makes no sense at all, but would be really grateful is anyone can help.

By: Stephen Brewin

Leave a Reply

Your email address will not be published. Required fields are marked *