I need help using a vlookup to match ‘most’ of a number. For example, Number 1234/1 to look for Number 1234

[Noswen869]

I know how to use the vlookup to use Number 1234 to search for Number 1234/1 but I can’t figure out how to do it the other way around

For context I am downloading data which will contain a series of Numbers in one column and in the column to the right there will contain dates

I want these dates to populate onto my main tab however if he Numbers do not quite match. See example in title

Any help would be greatly appreciated

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you are after?
If not, please give us some representative sample data and the expected results with XL2BB so we can easily copy for testing.

23 07 18.xlsm
	A	B	C	D	E	F
1
2	1234/1	19/07/2023			1111	13/07/2023
3	5678	15/07/2023			5896	14/07/2023
4	235	18/07/2023			5678	15/07/2023
5	123658/89	17/07/2023			12365889	16/07/2023
6					123658	17/07/2023
7					235	18/07/2023
8					1234	19/07/2023
9
lookup

Cell Formulas
Range	Formula
B2:B5	B2	=VLOOKUP(LEFT(A2,FIND("/",A2&"/")-1)+0,E$2:F$8,2,0)

 

[Noswen869]

Welcome to the MrExcel board!

Is this what you are after?
If not, please give us some representative sample data and the expected results with XL2BB so we can easily copy for testing.

23 07 18.xlsm
	A	B	C	D	E	F
1
2	1234/1	19/07/2023			1111	13/07/2023
3	5678	15/07/2023			5896	14/07/2023
4	235	18/07/2023			5678	15/07/2023
5	123658/89	17/07/2023			12365889	16/07/2023
6					123658	17/07/2023
7					235	18/07/2023
8					1234	19/07/2023
9
lookup

Cell Formulas
Range	Formula
B2:B5	B2	=VLOOKUP(LEFT(A2,FIND("/",A2&"/")-1)+0,E$2:F$8,2,0)

Thanks Peter - struggling to get the add on to work. Will try and figure it out and get back to you

 

[Peter_SSs]

Thanks Peter - struggling to get the add on to work.

As well as the link in my signature block below, check this one too: XL2BB Icons greyed out

 

[Noswen869]

As well as the link in my signature block below, check this one too: XL2BB Icons greyed out

Appreciate that, I think I've got it working.

 

[Peter_SSs]

You have to select the range that you want to show before clicking Mini Sheet