PDA

View Full Version : Wildcards with Index Match Match



richardSmith
06-10-2014, 12:29 PM
I am using an Index-Match-Match formula which has worked great when the text matched from sheet1 to sheet2, but now they don't match exactly, so I was wondering if there was a way to use wildcards in the function? This is my current code -
=IFERROR(INDEX(Sheet2!$A$3:$Z$30,MATCH('Sheet1'!$B2,Sheet2!$A$3:$A$930,0),M ATCH('Sheet1'!C5,Sheet2!$A$3:$Z$3,0)),0) but now let's say for example sheet1 will show Water Hose or WaterHose and sheet2 will just show hose, so of course Match will not 'match' anymore. Is there a way I can account for this sort of thing?