vlookup with double no.

[htukaram]

dear sir

please solve the case with vlookup

its a vehicle data. which chassis no will be double times, but when i applying vlookup formula. its capturing 1st data only, dublicate with remain same....i want dublicate different.

i have attached the sample sheet...

 

[htukaram]

need support

 

[Thangavel]

need support

Hello htukaram,
You can use Index formula instead of vlookup. Please find the attached file for your reference I've updated the Index formula in column "E" in vlookup sheet.
Regards,
Thangavel D

 

[NARAYANK991]

Hi ,

Another method.

Narayan

 

[Thangavel]

Hi ,

Another method.

Narayan

Hello Narayan,
could you please explain the "=INDEX('vlookup range'!$C$2:$C$14, SMALL(IF('vlookup range'!$A$2:$A$14 = A2, ROW('vlookup range'!$A$2:$A$14) - MIN(ROW('vlookup range'!$A$2:$A$14)) + 1), COUNTIF(A$2:A2, A2)))" this formula..i'm not able to get it..!!

 

[NARAYANK991]

Hello Narayan,
could you please explain the "=INDEX('vlookup range'!$C$2:$C$14, SMALL(IF('vlookup range'!$A$2:$A$14 = A2, ROW('vlookup range'!$A$2:$A$14) - MIN(ROW('vlookup range'!$A$2:$A$14)) + 1), COUNTIF(A$2:A2, A2)))" this formula..i'm not able to get it..!!

Hi ,

Can you see if this helps :

https://answers.microsoft.com/en-us...e/0f258553-fd5f-47bb-99f1-ec72dc4e6135?auth=1

Narayan

 

[Thangavel]

Hi ,

Can you see if this helps :

https://answers.microsoft.com/en-us...e/0f258553-fd5f-47bb-99f1-ec72dc4e6135?auth=1

Narayan

Thank you!!

 

[htukaram]

Hello htukaram,
You can use Index formula instead of vlookup. Please find the attached file for your reference I've updated the Index formula in column "E" in vlookup sheet.
Regards,
Thangavel D

Sir JI

Superb....Thanks