+ Reply to Thread
Results 1 to 3 of 3

Searching a table for multiple criteria to return single result

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Nebraska
    MS-Off Ver
    Office 365
    Posts
    84

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├┤ Pew Pew
    Posts
    441

    Re: Searching a table for multiple criteria to return single result

    I just reread what you want, I'll redo this quick. Actually I am still not positive what you are trying to get. Are you trying to populate the column T on the Approved tab with something and then look up if it is approved off the approved table?
    Last edited by Hawkeye16; 06-16-2014 at 09:00 AM.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    Nebraska
    MS-Off Ver
    Office 365
    Posts
    84

    Re: Searching a table for multiple criteria to return single result

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Searching multiple worksheets in a workbook and return the result to sheet1
    By wychen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2013, 02:35 AM
  2. Replies: 7
    Last Post: 09-06-2013, 11:59 PM
  3. Search for multiple criteria then return result
    By ctrapper in forum Excel General
    Replies: 7
    Last Post: 03-15-2011, 09:03 PM
  4. Return Result based on Multiple Criteria
    By franciz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-20-2009, 01:30 PM
  5. return single result from multiple rows
    By tracemul7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2008, 02:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1