Search results for query: *

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...

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...

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...

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...

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

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...

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

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...

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...

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.

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...

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!