+ Reply to Thread
Results 1 to 4 of 4

Lookup for any one of 2 conditions and plot entire column

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Lookup for any one of 2 conditions and plot entire column

    Hello Friends

    Please find the attached file (Lookup for any one of 2 conditions and plot entire column.xlsx).

    In Light green Cell CF2 if any texts from G4:CC4 or any number from G5:CC5 is entered then

    the entire column datas to be plotted in light yellow cells CH9:CH45.

    thanks in advance.
    regards

    thilag

  2. #2
    Valued Forum Contributor
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2010
    Posts
    505

    Re: Lookup for any one of 2 conditions and plot entire column

    Maybe this option will do.
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Lookup for any one of 2 conditions and plot entire column

    Or a non array method.

    =IF($CF$2="","",INDEX($G6:$CC6,MATCH($CF$2,IF(ISNUMBER($CF$2),$G$5:$CC$5,$G$4:$CC$4),0)))

  4. #4
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Lookup for any one of 2 conditions and plot entire column

    Hello Czeslaw and Jason

    Thank you.

    Both your formulas working well. thanks again

+ 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] Entire row text color defend upon lookup in column J Cells
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2015, 04:29 AM
  2. Need help copying HLOOKUP down entire column of lookup values
    By konatown in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2015, 04:28 PM
  3. [SOLVED] 2 Column Lookup with 6 Column array Col index number is Varies Within Entire Array
    By Weasyb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-05-2015, 12:54 PM
  4. lookup for a cell value in entire sheet and return value from a column
    By atulkumar.goel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2014, 01:38 PM
  5. [SOLVED] Text results with two conditions (lookup with two conditions)
    By Davzx in forum Excel General
    Replies: 8
    Last Post: 05-25-2012, 03:08 AM
  6. not showing blanks when using lookup for entire column
    By NinjaBear in forum Excel General
    Replies: 1
    Last Post: 11-22-2011, 11:24 AM
  7. Lookup Value in Column return entire row
    By Soybean in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2008, 07:40 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