Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DragonRe

    displaying multiple results from index/match search

    Well I think it was a good example :p Plus, I like sandwiches. It seems like we are not quite on the same page yet. I have a list of unique results, as well as a list of unique item1/item2 (they happen to be the same). Here is a posted version of my file. Only of course it doesn't function...
  2. DragonRe

    displaying multiple results from index/match search

    The information is in pairs, because it's important that it comes in pairs. The turkey bacon thing is just a dummy example, here is a sample of my actual data: results item1 item2 Abaddon Flame (FIRE) Bomb Core Chocobo Feather Abaddon Flame (FIRE) Bomb Core Chocobo Wing...
  3. DragonRe

    displaying multiple results from index/match search

    Sorry I provided what I wanted as the solution, not what we were starting with. The problem is that the data comes in pairs of information, like in my answer "turkey bacon". recipe item1 item2 sandwich turkey bacon sandwich beef cheese sandwich chicken tomato burrito beans...
  4. DragonRe

    displaying multiple results from index/match search

    Ok, having a bit of a miscommunication. Say I want to have a drop down box of choices of meals to make. Lets say someone chooses "sandwich". I then want excel to display all the ways that "sandwich" could be made. EX: sandwich beef cheese turkey bacon chicken tomato As it is...
  5. DragonRe

    displaying multiple results from index/match search

    Could you humor me and give me an example? Whenever I use index with offset I can only get it to display one thing.
  6. DragonRe

    displaying multiple results from index/match search

    I'm having problems using offset in this application. It will only ever display one result, where I would think it would return an array of cells. Code EX: =OFFSET(B:B,MATCH(B1,B:B,0),1,COUNTIF(B:B,B1),1) which to my understanding means: go to column B, find where "B1" is, display whats in the...
  7. DragonRe

    displaying multiple results from index/match search

    You are a wizard! It'll take a little time to implement, but this is perfect. I'll let you know how it goes.
  8. DragonRe

    displaying multiple results from index/match search

    I am using index/match to find something in column B, and then output column C and D. There are typically multiple matches, this is always finding just the first one. My data is sorted in alphabetical order descending based on column B. Therefor all my matches will be one after another...
  9. DragonRe

    creating arrays from non-neighbor columns

    Oh, well, my question was: how can you make an array out of non-neighbor columns :) For example, I'm using index/match to look at columns A B and D, but I have to specify "A:D" which includes C. I don't believe this is causing any inefficiency because it's not actually having to search through...
  10. DragonRe

    creating arrays from non-neighbor columns

    Hopefully you'll read this Skip, I just got index/match working. It's much more elegant and less magic than vlookup. My original question is still not answered, but even better you gave me the solution to the root issue.
  11. DragonRe

    creating arrays from non-neighbor columns

    Background: I'm making a spreadsheet to help people use Rikku's "Mix" ability in FFX (then I'll add more content to it). I've already created functionality that takes two "ingredients" and tells you what the result is. I've done this with both VBA and build in excel functions: ie vlookup, as an...
  12. DragonRe

    creating arrays from non-neighbor columns

    Hello, is there a way (without using VB) of making an array without a column in between? For example I want an array that is column A and column C but *not* column B. I'm using this in conjunction with vlookup. Thanks!

Part and Inventory Search

Back
Top