Report

Verifing-Vin Numbers [Solved/Closed]

Ask a question AndreOrion 3Posts Wednesday May 11, 2016Registration date May 12, 2016 Last seen - Last answered on May 16, 2016 at 06:38 AM by 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

Helpful
+0
plus moins
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.
Helpful
+0
plus moins
Good Morning, Thank you so much for your assistance.
Helpful
+0
plus moins
AndreOrion, Good evening.

Did you solve your question?

--
Belo Horizonte, Brasil.
Marcílio Lobão
AndreOrion- May 16, 2016 at 06:38 AM
Good Morning,

Question is solved, Thank You So Much...

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!