I am trying to create a formula but really struggling! I’ll attempt to describe what I’m trying to do:
- Worksheet1 A1 value “Apple”
- Look for same value in Worksheet2, range A1:A10
- Where a match is found look up value from Worksheet 2, B1:B10 (e.g. “Fred”)
- 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