+ Reply to Thread
Results 1 to 15 of 15

How to find a result when you need to search a number of columns

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: How to find a result when you need to search a number of columns

    Is there no way of searching the two columns A and B in Sheets 1 to identify the look up value either 4G,5G,AZ,ZZ the reason I ask is because there will not always be a 'G' in the area, it could be varied but will never have the exact same letters and numbers. If I could look up the two columns it would make it much easier for me, in the report i'm going to build there could be 20 different codes in Area(column A) and even more codes in Site(column B).

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: How to find a result when you need to search a number of columns

    Change formula to:

    =IFERROR(INDEX(Sheet1!$F$2:$F$29,MATCH(1,(Sheet1!$A$2:$A$29=$C$2)*(Sheet1!$C$2:$C$29=$B5)*(Sheet1!$E$2:$E$29=C$4),0)),INDEX(Sheet1!$F$2:$F$29,MATCH(1,(Sheet1!$B$2:$B$29=$C$2)*(Sheet1!$C$2:$C$29=$B5)*(Sheet1!$E$2:$E$29=C$4),0)))

    copied and press CTRL-SHIFT-ENTER button together

    and drag down and cross
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: How to find a result when you need to search a number of columns

    Thanks Azumi that is exactly what I am looking for. Really appreciate your help.

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: How to find a result when you need to search a number of columns

    Yes you're welcome, happy to help

+ 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. Search, find and add the result in a specific location
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2011, 10:42 AM
  2. Find column character search result
    By Lithium in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2009, 12:05 PM
  3. How to use Form to Find and Display Search Result
    By xinzie in forum Excel General
    Replies: 1
    Last Post: 03-28-2009, 05:46 AM
  4. Search in Mulitple Columns and Return Corresponding Column/Row Result
    By JLRO in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2008, 10:42 AM
  5. Search another Workbook to find result
    By brown_toby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2006, 04:14 PM

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