Previous Topic Next Topic

Verifing-Vin Numbers

Solved/Closed
AndreOrion Posts 3 Registration date Wednesday May 11, 2016 Status Member Last seen May 12, 2016 - May 11, 2016 at 04:45 PM
 AndreOrion - May 16, 2016 at 06:38 AM
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 responses

Answer 1 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 11, 2016 at 05:36 PM
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.
0
Answer 2 / 3
AndreOrion Posts 3 Registration date Wednesday May 11, 2016 Status Member Last seen May 12, 2016
May 12, 2016 at 12:31 PM
Good Morning, Thank you so much for your assistance.
0
Answer 3 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 12, 2016 at 09:54 PM
AndreOrion, Good evening.

Did you solve your question?

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

Question is solved, Thank You So Much...
0

Similar discussions

I'm not receiving yahoo verification code on my phone
rote -
FrPaulinusIkeOgara -

6 responses