+ Reply to Thread
Results 1 to 4 of 4

Lookup and return a value from a table

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    Reykjavik, Iceland
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    2

    Lookup and return a value from a table

    I hope someone can help me.

    I can't seem to remember the best way to return a value from a table based on column and row headers. For instance, I would need the formula to return a value from column header 4 and row header 130. Can anyone help?

    salary.xlsx

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Lookup and return a value from a table

    INDEX/MATCH is probably the easiest way.
    See attached for an example.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-04-2014
    Location
    Reykjavik, Iceland
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    2

    Re: Lookup and return a value from a table

    Thank you so much, this really helps.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Lookup and return a value from a table

    Not a problem. Happy to help.

    Don't forget to mark the thread as SOLVED if you're happy with the solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. LOOKUP TABLE -blank cell in the table array to return a figure
    By jonnops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2014, 09:08 AM
  2. Lookup a blank cell in a Lookup table and return a figure.
    By jonnops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 07:33 AM
  3. Lookup value in a table, return cell below
    By burlywood66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2013, 11:16 AM
  4. Trying to return value based on lookup in table
    By jnrexcel in forum Excel General
    Replies: 10
    Last Post: 05-31-2011, 09:00 AM
  5. Lookup and return data after using ref table
    By richardj in forum Excel General
    Replies: 3
    Last Post: 09-11-2009, 09:25 AM

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