+ Reply to Thread
Results 1 to 10 of 10

Lookup to find cell and use formula in it?

  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    4

    Lookup to find cell and use formula in it?

    I am trying to get lookup to find a cell and use the formula in the cell.
    I have a lot of different formulas arranged in different cells. (Columns J, K, L)
    it starts out with a coordinat set X and Y. First we need to figure out what interval X fits in.
    Then we need to look at the three different formulas in columns J, K and L. Wich furmula is true for the coordinat set.
    Finally we need it to return the sentence in J6, K6 or L6

    For instance X=1.6 and Y=0.9

    X fits with the interval in row 11 (H11)

    then we need to figure out wich of the three formulas are true?

    I’m trying to do this, so I only have to write the formulas in one place.
    I can get the lookup to return a value in the right cell, but if I have a formula in that cell, I can’t figure out how to solve the formula.

    I have a lot of coordinat sets.

    Name: Udklip.PNG Views: 25 Size: 77.5 KB
    Attached Images Attached Images
    Last edited by AliGW; 11-16-2018 at 01:29 AM.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Lookup?

    Hi

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Lookup?

    Hi

    See the attached file,
    I have used a simple UDF to evaluate the formula as below

    HTML Code: 
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-13-2018
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    4

    Re: Lookup?

    I think i posted a test file here
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Lookup?

    Hi
    Changes made in your file (attached)
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-13-2018
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    4

    Re: Lookup?

    Hi Sadath31

    this looks promising, how do you run the private function?
    I comes upp with either #N/A or #VALUE!

    Looks like it doesn't recognize the UDF

  7. #7
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Lookup?

    Maybe your macro security? Check "Macro Security" on the Developer tab of the ribbon. Make sure that it is set to "Disable all macros with notification" then close the workbook. When you reopen it you will get the opportunity to enable macros.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: Lookup to find cell and use formula in it?

    Please read the forum rules regarding thread titles, which should be more descriptive than yours was. I have changed it for you this time - next time please make sure your thread title is more explicit. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  9. #9
    Registered User
    Join Date
    11-13-2018
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    4

    Re: Lookup to find cell and use formula in it?

    Thank you all Saddath31 and Geoffw283, that did the trick!
    And thx for changing the topic AliGW

    BR
    Morten

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,428

    Re: Lookup to find cell and use formula in it?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Lookup: Lookup employee id and return value in cell x basued on most recent start date
    By jekeith in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2018, 12:56 PM
  2. Two Lookup and Return (Lookup the column, then lookup the row)
    By Branbran10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 04:55 PM
  3. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  5. Replies: 2
    Last Post: 05-19-2013, 08:46 AM
  6. Search lookup array to find lookup value contained within text string
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2011, 09:42 AM
  7. Replies: 7
    Last Post: 06-19-2011, 12:51 PM

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