Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
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
This should fix the problem
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
Re: Vlookup across Multiple Sheets with multiple results
Are you looking for something that will look like this?
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
Sorry, bit of a mix up with files. Here is your new file to look at
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
See if this is what you want?
Re: Vlookup across Multiple Sheets with multiple results
Holy moly, that's perfect! You're quite possibly an Excel deity, haha.
Re: Vlookup across Multiple Sheets with multiple results
LOL. I have my doubts, but thanks. Glad to have helped!
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.
Don’t have an account yet? Register yourself now and be a part of our community!
