JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Well, I've tried to add COUNTIF to an INDIRECT VLOOKUP formula. I've added "COUNTIF(" just before the VLOOKUP with no success.
Here is my formula that I need to add a COUNTIF added. I want the VLOOKUP results to tell me how many results did it find. Thank you so much!
Here is my formula that I need to add a COUNTIF added. I want the VLOOKUP results to tell me how many results did it find. Thank you so much!
Excel Formula:
=IF(K12="Off/Vacation","--",
VLOOKUP("*"&K12&"*",INDIRECT(K$8&"!M:M"),1,0))