Help required with VLOOKUP for partial cell match

[GLOpro]

Hi,

How would i go about setting up a VLOOKUP for a partial sequence:
ie. vlookup 249044311 where the array would show A0249044311.

thanks in advance!

 

[DebugGalpin]

Could use an index match formula if you need the look up.

to find the row checking column A (change that as required)
= Match("*249044311*",A:A,0)

=Index( array, match formula above, column number you want)

 

[GLOpro]

Hi DebugGalpin,

thanks for your reply.

I dont understand how to implement your suggestion.

Sheet 1, cell D2 is 249044311
check array on Sheet 2 B1:B50 till it finds A0249044311
then insert corresponding Column Number 12 data into Sheet1 Col 2

I hope I havent confused the outline further

 

[DebugGalpin]

No worries I've changed it up to go in cell B2 sheet 1

=INDEX(Sheet2!$1:$1048576,MATCH("*"&D2&"*",Sheet2!$B:$B,0),12)

First part of the Index is the array, I am assuming you have data in sheet2
Second part I match a wild card of cell D2 to Sheet 2 column B to give me a row number
Third part I return column 12 as column number

B2 equals Sheet 2 Cell (L whatever the row number is)