Verifing-Vin Numbers Solved/Closed

Question

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

Configuration: Windows 7 / Mozilla 11.0

Mazzaropi · Answer

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.

AndreOrion · Answer

Good Morning, Thank you so much for your assistance.

Mazzaropi · Answer

AndreOrion, Good evening.
 
Did you solve your question?

 --
Belo Horizonte, Brasil.
Marcílio Lobão

Verifing-Vin Numbers

3 responses

Similar discussions

Subscribe To Our Newsletter!