+ Reply to Thread
Results 1 to 3 of 3

another lookup- lookup column against row inputs

  1. #1
    Registered User
    Join Date
    01-13-2004
    Posts
    42

    another lookup- lookup column against row inputs

    Hi, it's me again:
    I asked a similar question to the below but I tried using a vlookup formula, VLOOKUP(J8,J25:S28,ROW(A26),0), but get a ref# error.

    Can you please assist with a formula that will lookup an identifier in column J (J8 to J17) against the same identifier in row 25 (J25 to S25) and return values corresponding ie values in rows 26 to 28 of the attached. Thank you.lookuptest1.xlsx

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: another lookup- lookup column against row inputs

    You may want a horizontal lookup, not a vertical lookup
    =HLOOKUP(J8,$J$25:$S$28,2)

  3. #3
    Registered User
    Join Date
    01-13-2004
    Posts
    42

    Re: another lookup- lookup column against row inputs

    Thanks a lot Dave.

+ 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