Hi, I am Autumn from Corvallis, Oregon. I am a cost and forecasting analyst who spends countless hours in Excel, trying to make it do more than expected while maintaining a slick interface for my users. I was so pleased when my brother recommended this site!
For each value in List 1 you can determine how many are represented in List 2 by using countif and a wild card for the List 1 value:
COUNTIF(E$2:E$11,"*"&A2&"*") or Countif(range for list 2,"*"value from list 1"*")
Availability can now be determined based on the result: If the result for the...