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)
Bookmarks