Searching a table for multiple criteria to return single result

Hello,
I am trying to come up with a better way to track wether or not a particular truck is an "Approved" or "Not Approved" hauler. In the file attached the person has to manually enter in the values in Column B in the totals page and then look in the table on sheet Approved Trucks to see if they are approved or not. I would like to come up with a formula that would take the value entered into Column B on the Totals and check the table to see if they are an approved hauler.

I have an example of what I was trying to do on the Approved Trucks page, but it only looks for one particular row on the sheet. I would need to have somethig that looks through the whole table. I attempted to use a Vlookup nested inside and IF but was not able to get that to work. Any help would be greatly appreciated.

Thanks,
Eric

I think that I have something figured out now using Vlookup. I have attached a revised version of my sample file with what I am doing and trying to have the sheet do. On the 'TOTAL DBE CREDIT' page I am wanting column G to auto populate with either DBE or Non DBE. Right now it is searching Column B (truck #) for a match in the 'Approved Truck' page and recording the DBE status. The cells that I have highlighted yellow are errors in the formatting and returning innaccurat results. I hope this helps to clear things up.

Thanks,
Eric