Index / Match function question

[dolphn22]

Hi all,

I think the best thing for me to do is give an example as I am unsure how to explain it.

I have data in column A in a tab labeled "Banking". The data in cell A1 is xxxxx1043xxxxx. I have a list of numbers in column A in the tab "matching". 1043 is one of the numbers. I want to cross reference A1 on the banking tab to column A on the matching tab and pull the data in column B next to the match. Typically, I use an index / match formula to do this. However, becuase it is not an exact match, it doesn't work.

Can anyone help me create a formula to be able to accomplish this task. I can breakout all of the numbers out, but unfortunately, the # of characters and such don't line up so it is very time consuming. i want to be able to cross refernce the two leaving the extra data in and still get the same result.

Any guidance here would be very greatly apprciated.

Thank You,
Darrin

 

[jackhandey]

You can still use an exact match, but put the wildcard tags on either side of 1043 in the match function. So instead of MATCH(

#VALUE!

 

[dolphn22]

You can still use an exact match, but put the wildcard tags on either side of 1043 in the match function. So instead of MATCH(

#VALUE!

#VALUE!