Results 1 to 8 of 8

Nesting multiple Vlookup conditions in an If funciton

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2003
    Posts
    4

    Thumbs down Nesting multiple Vlookup conditions in an If funciton

    I am not sure if the VLookup or the If function will be the best way to perform this tast but I think it is they way I would want to go.

    I have attached a sample workbook of what I am working with.
    Please refer to it.

    On sheet 1 I named the table array Ear_Tag.

    This is information that is provided to me from the farmers.

    Note that there are sometimes more then 1 pig with the same tag number. The only way to tell them apart is by the Test Date.

    On Sheet 2
    Is where I record the test results.

    I dont want to have to look up each pig after each test and fill in the rest of the cells manually. I would like to have a look up of the ear tag and the test date to find the correct pig. Then each of the cells will fill in the correct information.

    If you can help solve this problem for me I would be ever so thankful.
    Thanks
    Amy
    Attached Files Attached Files
    Last edited by AMSTARR; 09-24-2009 at 11:05 PM. Reason: Spelling

Thread Information

Users Browsing this Thread

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

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