ABCDEFGHIJ
1
Given a numeric VANID, you can compute the URL for the profile page in NGP. eg given VANID of 55,895, the URL is https://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID75ADQ. So, how can you compute that URL param, EID75ADQ?

It is composed of three parts:
1) the constant prefix "EID"
2) The VANID in hexadecimal, reversed (what I call inhexrev below)
eg for 55,895, in hexadecimal is "DA57", and then that reversed is "75AD"
3) A single character suffix of cycling from "A" through "Q", eg a VANID of 0->A, 1->B, 2->C, ..., 16 -> Q, 17 ->A, 18 -> B, etc
eg for 55,895, the single character suffix is Q		Given a URL of a profile page, you can compute the VANID. This is just the inverse process.
2
=BASE(VANID, 16)=JOIN(
"",
ARRAYFORMULA(
MID(
inhex,
SEQUENCE(
LEN(inhex), 1, LEN(inhex), -1
),
1
)
)		=MID(
"ABCDEFGHIJKLMNOPQ",
MOD(VANID, 17) + 1,
1
)		="EID" & inhexrev & suffix=LET(
vanid,<INPUT_CELL_EG_A1>,
inhex, BASE(vanid, 16),
inhexrev, JOIN("",ARRAYFORMULA(MID(inhex,SEQUENCE(LEN(inhex),1,LEN(inhex),-1),1))),
suffix, MID("ABCDEFGHIJKLMNOPQ", MOD(vanid, 17) + 1, 1),
"https://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID" & inhexrev & suffix
)		=REGEXEXTRACT(
URL,
"VANID=EID([0-9A-F]+)[A-Q]"
)		=JOIN(
"",
ARRAYFORMULA(
MID(
inhexrev,
SEQUENCE(
LEN(inhexrev), 1, LEN(inhexrev), -1
),
1
)
)		=DECIMAL(inhex,16)=LET(
url, <INPUT_CELL_EG_A1>,
inhexrev, REGEXEXTRACT(url, "VANID=EID([0-9A-F]+)[A-Q]"),
inhex, JOIN("",ARRAYFORMULA(MID(inhexrev,SEQUENCE(LEN(inhexrev),1,LEN(inhexrev),-1),1))),
decimal(inhex, 16)
)
3
VANIDinhexinhexrevsuffixURL ParamURLinhexrevinhexVANIDVANID
4
111BEID1Bhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID1B1111
5
222CEID2Chttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID2C2222
6
333DEID3Dhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID3D3333
7
444EEID4Ehttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID4E4444
8
555FEID5Fhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID5F5555
9
666GEID6Ghttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID6G6666
10
777HEID7Hhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID7H7777
11
888IEID8Ihttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID8I8888
12
999JEID9Jhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID9J9999
13
10AAKEIDAKhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDAKAA1010
14
11BBLEIDBLhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDBLBB1111
15
12CCMEIDCMhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDCMCC1212
16
13DDNEIDDNhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDDNDD1313
17
14EEOEIDEOhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDEOEE1414
18
15FFPEIDFPhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDFPFF1515
19
161001QEID01Qhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID01Q01101616
20
171111AEID11Ahttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID11A11111717
21
181221BEID21Bhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID21B21121818
22
191331CEID31Chttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID31C31131919
23
201441DEID41Dhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID41D41142020
24
211551EEID51Ehttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID51E51152121
25
221661FEID61Fhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID61F61162222
26
231771GEID71Ghttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID71G71172323
27
261AA1JEIDA1Jhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDA1JA11A2626
28
271BB1KEIDB1Khttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDB1KB11B2727
29
281CC1LEIDC1Lhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDC1LC11C2828
30
291DD1MEIDD1Mhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDD1MD11D2929
31
301EE1NEIDE1Nhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDE1NE11E3030
32
311FF1OEIDF1Ohttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDF1OF11F3131
33
322002PEID02Phttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID02P02203232
34
332112QEID12Qhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID12Q12213333
35
342222AEID22Ahttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID22A22223434
36
352332BEID32Bhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID32B32233535
37
362442CEID42Chttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID42C42243636
38
372552DEID52Dhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID52D52253737
39
382662EEID62Ehttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID62E62263838
40
55,895DA5775ADQEID75ADQhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID75ADQ75ADDA575589555895
41
55,896DA5885ADAEID85ADAhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID85ADA85ADDA585589655896
42
55,897DA5995ADBEID95ADBhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID95ADB95ADDA595589755897
43
55,898DA5AA5ADCEIDA5ADChttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDA5ADCA5ADDA5A5589855898
44
55,899DA5BB5ADDEIDB5ADDhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDB5ADDB5ADDA5B5589955899
45
55,901DA5DD5ADFEIDD5ADFhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDD5ADFD5ADDA5D5590155901
46
55,902DA5EE5ADGEIDE5ADGhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDE5ADGE5ADDA5E5590255902
47
55,903DA5FF5ADHEIDF5ADHhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDF5ADHF5ADDA5F5590355903
48
55,904DA6006ADIEID06ADIhttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EID06ADI06ADDA605590455904
49
337,0525249CC9425KEIDC9425Khttps://www.targetsmartvan.com/ContactsDetails.aspx?VANID=EIDC9425KC94255249C337052337052