+ Reply to Thread
Results 1 to 6 of 6

Help with a cell that has a value in it and trying to get vlookup to work with it

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    3

    Help with a cell that has a value in it and trying to get vlookup to work with it

    Hi everyone, I need help. I have a Vlookup function with a Max function mixed with it and it works, the results are displayed in H3. I need another function that will display the coerresponding cell that the value in h3 is next to. any help would be great. file is attached
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help with a cell that has a value in it and trying to get vlookup to work with it

    Do you mean?

    =VLOOKUP(H3,A7:H90,2)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-15-2012
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with a cell that has a value in it and trying to get vlookup to work with it

    Where H3 gets its value is from column B i need to be able to have excel match where it gets the information for H3 to the corresponding mandrel number in column A. Then have it display in H4

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help with a cell that has a value in it and trying to get vlookup to work with it

    Is the answer for this sample 6? if so, then my formula returns that... if not, then what should the answer be for the 33 and why?

  5. #5
    Registered User
    Join Date
    06-15-2012
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with a cell that has a value in it and trying to get vlookup to work with it

    In the cell in I3 i need it to read BS which is cell A75. Since 33 the number of times that mandrel has been scanned. But this will be an ongoing sheet so the numbers for the amount scanned May change in the future. Thank you for all your help
    Last edited by Chris.spalding.nde; 06-15-2012 at 12:35 PM.

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help with a cell that has a value in it and trying to get vlookup to work with it

    Try =INDEX($A$7:$A$75,MATCH(H3,$B:$B,0))

+ Reply to Thread

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