Vlookup across Multiple Sheets with multiple results

  • Re: Vlookup across Multiple Sheets with multiple results


    This might be a dumb moment for me, but if I want other names aside from 'asdf', what would I have to do? Also, to pull from range C:D, do I just modify this portion of the code?

    Code
    1. LARGE(ROW($C$1:$C$400)*($C$1:$C$4000
  • Re: Vlookup across Multiple Sheets with multiple results


    Well I setup the "Function" sheet to currently hold 4 sheets. Once you change, the sheet names go on rows 100, 200, 300, 400, and so on. Once you change the sheet name on one of those rows it will update the data according to the sheet names. So if you have a "Data" sheet, then type in "Data" or any other sheet name into D1 and C1:C99 should update with it

  • Re: Vlookup across Multiple Sheets with multiple results


    I understand what was happening now. One word sheet names work perfectly, but any spaces in the sheet names tend to break it. That's where I was having my issues. Is there a workaround for spaces in sheet names that could be recognized?

  • Re: Vlookup across Multiple Sheets with multiple results


    Hey, hey! That works beautifully!2 questions and i'm out of your hair. Can you explain how to add the range of C:D for results? And if I want to add more sheets, I just drag the formula past the existing formulas in 'Function'?Thank you.

  • Re: Vlookup across Multiple Sheets with multiple results


    So are you saying you want results from columns C and D? =IFERROR(IF(COUNTIF(INDIRECT(CONCATENATE("'",???,"'!",CELL("address",A2))),"=*" & Sheet4!$G$2 & "*")=1,INDIRECT(CONCATENATE("'",???,"'!",CELL("address",D2))),0),0) To add more sheets put in this equation and copy down as far as need be. The ??? will be the cell reference to the sheet's name.

  • Re: Vlookup across Multiple Sheets with multiple results


    Yes, there was additional information requested, so I needed to place it in C and pull from the range C:D. Is that possible? Also, ... yeah, one more question. When G2 is blank, everything from every sheet is displayed. Can I modify it so if G2 is blank, no resutls are dispalyed? Thank you so much.

  • Re: Vlookup across Multiple Sheets with multiple results


    I am curious if this same formula could pull the A column along with it. For example, search 'ice cream' and it pulls up all ice cream catergories (A), then range C:D. Is that possible?I swear, if you took donations, I would be the first to contribute.

  • Re: Vlookup across Multiple Sheets with multiple results


    Well I could take a look. But I think this is what you were asking for on the previous post. Please take a look

    Files

  • Re: Vlookup across Multiple Sheets with multiple results


    What was this new version supposed to do again? Was it the range of C:D? I'm testing it out and don't see a difference with my current version.

  • Re: Vlookup across Multiple Sheets with multiple results


    That's similar to what i'm looking for. Instead of loading the results from C mixed with results from D, can the results from C load in the next column? Is that a huge hassle? Thank you once again!

  • Re: Vlookup across Multiple Sheets with multiple results


    That would actually be easier on my part. And you also wanted column A to be pasted with the results as well?

  • Re: Vlookup across Multiple Sheets with multiple results


    That would be perfect, yes. Because when someone looks at the Function screen, they can see the results of their search as well as any pertaining information.

  • Re: Vlookup across Multiple Sheets with multiple results


    Once again.. it won't let me edit my post. So when I want to add a sheet, just copy the format that has been used on prior sheets? I want to add around 6 more sheets.

  • Re: Vlookup across Multiple Sheets with multiple results


    Yea. Just look at the pattern of what is going on in the Function sheet and do the same thing. You should just have to put in the first 3 formulas and the sheet name then copy the 3 formulas down. Then just make sure there is enough space to hold all your data.