I would like to do an INDEX / MATCH function or something similar for the following to return a date from 'Sheet2'
This formula works without a wildcard in text string search, however if a wildcard is inserted then the formula comes back '#N/A'. Is there something similar I can use? SUMPRODUCT?
In attached file I have included TABLE 1 (Wildcard Formula) and TABLE 2 (No Wildcard Formula) to show it works without a wildcard.
EDIT: FYI my separators I use is | since I use various codes in MS project as well. Use normal comma's and I'll transfer anything over. Sorry for any confusion.
Formula:=INDEX(Sheet2!$A$4:$E$14|MATCH(1|(Sheet2!$A$5:$A$14=Sheet1!C6)*(Sheet2!$B$5:$B$14="*Work*")|0)|3)
WILDCARD INDEX.xlsx
Bookmarks