Results 1 to 2 of 2

Thread: Formula to search multiple sheets and return specific cells from the matched row

  1. #1

    Formula to search multiple sheets and return specific cells from the matched row



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

    Morning,

    I can usually figure out my formulas between reading, experimenting and web examples but Im stuck on this one.
    I want to use data in column b, to check all other workbooks for a match. If a match is found, I want to return specific cells from the matched row.

    To explain, Ill use a little pseudo code

    use data in worksheet Master cell b1 to search all other sheets.
    if a match is found, return data populated in the columns b, d and e within the matched row.

    The result on Master of matching 12.10.10.12 would be

    12.10.10.12 WATER FELL DOWN


    I've attached an example workbook.

    Thanks a lot for the help. Been working this for a few days.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    No sheet attached...

    but take a look here. I think this will help.

    http://www.xl-central.com/lookup-single-criteria-multiple-sheets.html


Posting Permissions

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