VBA to return multiple matching values into a single cell

**ChipsSlave** · 04-29-2017, 02:51 PM

Hello,

Plan sheet - I got this file which returns me a matching route number referring to two criteria.
This is the sheet i use data fr sheet - where sheet plan is pulling the data from.

Problem I need to return multiple values into single cell if the criteria has matched. I don't know if this is possible working with only formulas and I have found a VBA which perfectly serves my needs but it's only matching to one criteria rather that for two. Could please have someone a look at it and help me to fit it into my spreadsheet?

Please Login or Register  to view this content.

Link to VBA code posted: https://superuser.com/questions/5362...ultiple-values

**mike7952** · 04-29-2017, 03:11 PM

Will Column A on worksheets(This is the sheet i use data sheet) only contain the numbers for the staging or will there also be other numbers in the cell. I could just use the worksheets(this is where I paste data) to create the output on the Plan sheet.

**ChipsSlave** · 04-29-2017, 04:09 PM

If it's possible to generate the table straight from the sheet where I paste data, go for it.

Sheet this is the sheet i use data fr is only for index match formula to work. If you can make Plan sheet to work straight from the sheet where i paste data in then its very good and it means that I can avoid from having extra sheets that contain the same information with some extra columns.

**mike7952** · 05-01-2017, 12:50 PM

Give this wb a try.

Please Login or Register  to view this content.

**ChipsSlave** · 05-02-2017, 09:29 AM

WoW!!! Thank you very much! Exactly what i have requested.

**mike7952** · 05-02-2017, 11:53 AM

Here is the small adjustment you wanted. Click hyperlink in Cell A1 to run Macro. Adjustments are highlighted in red.

Please Login or Register  to view this content.

Updated Workbook

**ChipsSlave** · 05-02-2017, 01:55 PM

staging02.JPG

For some reason it returns matching DSP only for 3,4 and 5 columns. Could you please have a look at this?

**mike7952** · 05-02-2017, 02:12 PM

My bad fixed the code in previous post. See code highlighted in green. Here

**ChipsSlave** · 05-02-2017, 02:18 PM

stagingv02.JPG

now code duplicates route codes

**mike7952** · 05-02-2017, 02:28 PM

My bad again lol, I copied and pasted wrong, This should do it, had and extra aStaging(i, 2) like below.
Also edited the previous code in Post #5

Change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

**ChipsSlave** · 05-02-2017, 02:37 PM

Thank you my dear. Cold and rainy greetings from UK to sunny Florida!

**mike7952** · 05-02-2017, 02:40 PM

Your welcome, and thanks for the rep. And Florida is warm and rainy here today.

Added a Custom Tab in the Workbook below to the end of your Menus Tab. See Image below.

**ChipsSlave** · 05-03-2017, 07:46 AM

Thank you very much for another update. But may I ask you for something more? I would like the spreadsheet to suggest us me the best staging area? I have added sheet called Staging areas with their locations and also added another column in the wave plan where it says which location dsp prefers the most. Would it be to much to ask from you?

**mike7952** · 05-03-2017, 07:58 PM

Originally Posted by ChipsSlave

Thank you very much for another update. But may I ask you for something more? I would like the spreadsheet to suggest us me the best staging area? I have added sheet called Staging areas with their locations and also added another column in the wave plan where it says which location dsp prefers the most. Would it be to much to ask from you?

Not sure that I'm following you correctly. Can you give me some more insight on what you are requesting?

**ChipsSlave** · 05-04-2017, 02:30 AM

Attachment 516223

I would like spreadsheet to suggest me where is the best place to stage the route. If FDTL primary staging location is front then check if 31 staging area is empty then suggest in 31 otherwise check 32 if occupied check 33. If none found in front look for free space in secondary location.

**mike7952** · 05-04-2017, 02:47 PM

In your uploaded example what is to happen with C1/WCD in row 3. What about A2/UKED,C2/WCDL in the next row. I know its easy for you to look at and know what it want, but I'm not seeing your ALL of your logic. Can you explain a little more?

**ChipsSlave** · 05-05-2017, 01:53 AM

Hi,

I have uploaded another file with much more detail and a sheet of what I would like to be done.

VBA to return multiple matching values into a single cell

LinkBack

Thread Tools

Rate This Thread

Display

VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Re: VBA to return multiple matching values into a single cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula to return multiple values in single cell not working

Lookup multiple values in a single cell (separated by commas) and then return the values

Return multiple values to single cell from array

[SOLVED] vLookup multiple values separated by ";" in single cell / return result in single cell

[SOLVED] How to return multiple values to a single cell based on multiple criteria

How to return multiple values from an array in a single cell?

How to return multiple IF values in a single cell?

Bookmarks

Bookmarks

Posting Permissions