Dear Sir, I wanted to find entry number from Vehicle number from sheet2.
S Shabbo Member Aug 22, 2019 #1 Dear Sir, I wanted to find entry number from Vehicle number from sheet2. Attachments ENTRY NUMBER AGAINST VEHICLE NUMBER.xlsx 14.4 KB · Views: 4
V vletm Excel Ninja Aug 22, 2019 #2 Shabbo for C2 =INDEX(Sheet2!A:A,MATCH(MID(B2,5,4) & " " & RIGHT(B2,2) & " " & LEFT(B2,4),Sheet2!C:C,0),1)
Shabbo for C2 =INDEX(Sheet2!A:A,MATCH(MID(B2,5,4) & " " & RIGHT(B2,2) & " " & LEFT(B2,4),Sheet2!C:C,0),1)