Results 1 to 10 of 10

Lookup to find cell and use formula in it?

Threaded View

  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.

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