return multiple values

Hi everyone, is there a excel vba code for fuzzy lookup that can return multiple values?

I have a spreadsheet that returns multiple results based on an order number in columns E to G. I would like to combine those results into a single cell with "/" as the delimiter into column H and have the sort order Auth/Sale/Credit. Some of the cells have only one result and the other cells...

Hello, This is my first post so please excuse me if I do something wrong. I have a workbook that contains approximately 260 sheets, uniquely named. Each sheet contains a row, say row 22 that is labeled in column A "Review Comments:". Column C through Column Z "MAY" contain text comments i.e...

I have some times that I am trying to analyze through the use of a helper column. In Column B I have a list of operation numbers, in Column G I have a list of time differences. In the helper column I want to check if the next 5 time differences for the same operation are under 7 minutes. In the...

Hi All, I'm cleaning a dataset and looking for no responses (blanks in the data). When there is no data in a given cell, I'd like to output: A) the ID # associated with that row which is the contents of another cell in the same row B) the string contents of another cell in the same column C)...

I want to create a user form where the user will enter a value in a designated cell, and once entered, either automatically or after running a macro, return all matching records on separate rows. So for example, lets say I have a dataset with 3 column; (1) Animal Type, (2) Animal Name, (3)...

Hello and sorry upfront, I'm sure this has been asked and answered lots of times but I can not make this work. Here is what I need to do: the info on Sheet1 has a bunch of names in Column V with info behind On Sheet 2 I need to lookup each match in Column V and return all the info for each...

I was trying to write a formula that will enable me to chose a school name (from a data validation dropdown list) and have 4 years of test scores come up. I wrote the following formula which works really well except for 1 small problem. It sorts the data for a given school in ascending order...

I am trying to generate a list of components that are on at least one part(Par 1, Part 2, Part 3, etc) but I want to exclude the components that are not any part. I generated this list in A11:A15. The formula I used was =IF(SUM(B3:G3)=0,"",A3) -- removed inline image --- That formula gives...

I have two columns of data. Column A has a category identifier number. Column B has specific item number. Multiple values under column B could fall under 1 value in column A. I need to return all values from column B which fall under a column A category. For example: below you will see in...

<TBODY> A</SPAN> B</SPAN> C</SPAN> D</SPAN> E</SPAN> 1</SPAN> 2</SPAN> Markets</SPAN> Markets</SPAN> Location Name</SPAN> 3</SPAN> Select Market here ></SPAN> 058 - Total Canada Market </SPAN> 063 - Total Northeast Market</SPAN> 064 -...

Hi, I'm trying to create an array formula that returns all the cities in a given state by imputing the state's abb in cell K2. The returned cities go into column J. California has the most cities(430) and the cities are 5000 rows deep, if that is helpful. Thanks