Results 1 to 5 of 5

Thread: Lookup a value in a range & find the cell in another range for further usage

  1. #1

    Arrow Lookup a value in a range & find the cell in another range for further usage



    Register for a FREE account, and/
    or Log in to avoid these ads!

    A6:L6 generates either 1 or 0 with a rule that ONLY 1 of the cell in the range (A6:L6) would be equal to 1.
    A2:L2 also generates values.
    I want to use the corresponding cell in the range A2:L2 for 1 generated in the A6:L6 for comparison with N2.
    N2 also generates a value.
    Output required: O2=If N2>=(cell from the range A2:L2) than 1000 else 2000.

    How to accomplish.
    Thanks
    Sheet1


    A B C D E F G H I J K L M N O
    1 Compare with Result
    2 200 450 250 150 175 200 400 100 200 500 555 185 200 2000
    3
    4
    5
    6 0 0 1 0 0 0 0 0 0 0 0 0

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,599
    Articles
    0
    Excel Version
    2010 on Xubuntu

  3. #3
    Sir I need help & it is urgent please.

  4. #4
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,599
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Sorry, I hate to lose time at answers others might already be working on

  5. #5
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    792
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Pecoflyer View Post
    Sorry, I hate to lose time at answers others might already be working on
    Here, here!
    Well said. Ive wasted loads of work on these !

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •