+ Reply to Thread
Results 1 to 6 of 6

Lookup a Code and Return Text

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Lookup a Code and Return Text

    On the "General Comments" sheet I have created a series of codes which match a general comment.

    I want to type these codes onto the "Student" sheet, under the ID column. What I want excel to do is match these codes to the corresponding "General Comment". This prevents copious amounts of retyping OR copying and pasting.

    Is there a lookup function that can match a code and return text in the adjacent cell?

    Comment Bank 1.xlsx

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

    Re: Lookup a Code and Return Text

    Check This Out

    http://www.davesexcel.com/vlookupweek.htm

  3. #3
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Lookup a Code and Return Text

    Student sheet b1 cell =

    =INDIRECT(ADDRESS(MAX(IFERROR(FIND(A11,'General Comments'!$C$6:$M$10),0)*ROW('General Comments'!$C$6:$C$10)),MAX(IFERROR(FIND(A11,'General Comments'!$C$6:$M$10),0)*COLUMN('General Comments'!$C$5:$M$5)+1),,,"General Comments")) Ctrl+Shift+enter
    Attached Files Attached Files
    Appreciate the help? CLICK *

  4. #4
    Registered User
    Join Date
    03-24-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Lookup a Code and Return Text

    Not quite what I was after.

    The problem is, I want a lookup function to match a code in multiple locations within a table.

    The function should lookup a code with the cells C8:C13 and find the corresponding comment and return it. Is there a function that not only cross checks a code in C8:C13 but also in D8:D13 and E8:E13?

  5. #5
    Registered User
    Join Date
    03-24-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Lookup a Code and Return Text

    That's fantastic!

    Disregard the last post as I sent it based on the first reply.

  6. #6
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Lookup a Code and Return Text

    Can you post file with desired result. Demonstrate the answer to understand better.

+ 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