Verifing-Vin Numbers

[Solved/Closed]
Report
Posts
3
Registration date
Wednesday May 11, 2016
Status
Member
Last seen
May 12, 2016
-
 AndreOrion -
Good Afternoon,

I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to compare and confirm the Vehicle Id Numbers in the USDOTALLBasics against the Vehicle Id Numbers in the Mobile Equipment List and report Vehicle Id Numbers that may be wrong or invalid?

Thank you so much for your assistance.

Andre

3 replies

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
AndreOrion, Good evening.

Off course there is.

As we don´t know the layout of your file we only can advise you generally.

The VLOOKUP or HLOOKUP or LOOKUP FUNCTIONS work well in these case.
Posts
3
Registration date
Wednesday May 11, 2016
Status
Member
Last seen
May 12, 2016

Good Morning, Thank you so much for your assistance.
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
AndreOrion, Good evening.

Did you solve your question?

--
Belo Horizonte, Brasil.
Marcílio Lobão
Good Morning,

Question is solved, Thank You So Much...

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!