Results 1 to 9 of 9

Matching values from 2 columns and returning the value in 3rd column

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    15

    Matching values from 2 columns and returning the value in 3rd column

    I have been trying to work out this formula for days without any luck. Please see attached file for a better udnerstanding of what I am trying to achieve.

    I need to lookup the value in column a and match this to a value in column b to return the value that appears in column e. For example, i want to know how much time Tim Smith has spent on training creation, then i would need to check a11 and b11 and the value i want the formula to return is e11.

    Please can someone assist with the formula I need to be using?

    Thanks in advance!
    Attached Files Attached Files

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