Please excuse my lack of proper technical terms as I am not that well versed in Excel.

My Lookup Value has more characters then the value I need to match in the the first column of the table array.

For example, a sample lookup value would be BM-A1472a-6x6, and the value in the first column is A1472a.

I need to retrieve data that is in the table array that contains the shorter string, so I can't flip flop and use the shorter string as my lookup value.

I have tried putting TRUE in the Range_lookup but it does not work.

I would appreciate any assistance you can offer me with this.

Thanks,
Jane