+ Reply to Thread
Results 1 to 4 of 4

Lookup matching value

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    57

    Lookup matching value

    Hello,

    So I'm trying to look up the a value and provide the name in an adjacent cell that corresponds to it. For instance I'm looking for the number 5 in a column and what the company name whose number that belongs to. Any suggestions???

    Thanks it's much appreciated!

    Rob

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,797

    Re: Lookup matching value

    Perhaps the VLOOKUP function?

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Lookup matching value

    I tried it but sometimes it returns the wrong value, because of the other functions I have in there some of the cells have #div/0 in them which for some reason throws it off.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,797

    Re: Lookup matching value

    Try =IFERROR(VLOOKUP(your_conditions),"") which will trap the errors ( also the N/A of course)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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