I'm having problems getting my partial match to work, i.e. "*"&A4&"*".....I know this is my issue. For example, I need to lookup "Item" from the string "Item-NewStock"..

Here's what I've got so far....I've tried it several different ways.


INDEX(Sheet1Lookup,MATCH("*"&A4&"*",'Sheet1'!$G$10:$G$14,0),1)