+ Reply to Thread
Results 1 to 7 of 7

LOOKUP value inside a range of values

  1. #1
    Registered User
    Join Date
    11-30-2022
    Location
    Australia
    MS-Off Ver
    Professional 2021
    Posts
    5

    Smile LOOKUP value inside a range of values

    Hello and thanks in advance for help on this one.

    I have attached a sample file.

    I'm wanting to type into one cell, in this case J5.

    Columns A to E are a table of data.
    In columns B and C are a post code.
    The post code entered in J5 should search the table, columns B and C, and identify which row is the post code range.
    It should then populate cell J7 with the relevant "rating" in column E.

    I've spent heaps of time trying to work it out but have failed.
    Thanks in advance
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 12-04-2022 at 06:37 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: help with lookup formula

    This one?
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: help with lookup formula

    Or this one?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: LOOKUP value inside a range of values

    Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since you are a new user of this site, on this occasion, I have changed it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    *Other search engines are available!!!

    Regards,

    Glenn.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  5. #5
    Registered User
    Join Date
    11-30-2022
    Location
    Australia
    MS-Off Ver
    Professional 2021
    Posts
    5

    Re: LOOKUP value inside a range of values

    Gee, sorry. I'll try harder with future posts.

  6. #6
    Registered User
    Join Date
    11-30-2022
    Location
    Australia
    MS-Off Ver
    Professional 2021
    Posts
    5

    Re: help with lookup formula

    Thank you to tanasedn and HansDouwe for your answers to solve my problem

  7. #7
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: LOOKUP value inside a range of values

    I'm glad to have helped. Thanks for your feedback.

    Please consider adding reputation to the answers of all helpers you think deserve.

    EDIT: Thanks for the rep. .
    Last edited by HansDouwe; 12-04-2022 at 11:41 AM.

+ 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. [SOLVED] how to lookup the words which is inside the sentence and using lookup formula to get data?
    By sagarkarki69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2021, 08:52 AM
  2. Help with adjusting Index lookup formula to include additional lookup criteria
    By kingofcamden in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2018, 01:04 PM
  3. Replies: 3
    Last Post: 08-23-2017, 07:04 PM
  4. [SOLVED] Modified LOOKUP Formula for Excluding Missing Lookup Values
    By aaochsner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2017, 07:29 PM
  5. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  6. [SOLVED] Lookup formula to find lowest value with variable lookup criteria
    By brharrii in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2015, 03:00 AM
  7. Replies: 5
    Last Post: 02-24-2011, 11:26 AM

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