Vlookup - result multiple values

[piethein123]

Hi , i'm looking for a formula that generates all value outcomes based on the condition.
So for example , in column A my condition is "A" , this "A" is spread out over 3 rows with values of 25 , 26 ,27
i wnat the formula to show me all 3 values instead of the 1st one it encounters.

thanks for your help

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[piethein123]

I cannot post - i think the conditions that i gave were quite simple to understand. Wondering if someone knows a formula for it?

 

[Fluff]

I cannot post

Why not?

 

[piethein123]

company policy does not allow that. Can someone help with this simple quesiton?

 

[Fluff]

Can someone help with this simple quesiton?

Yes but I need to see exactly what you have.

company policy does not allow that

Do you mean you cannot use the Add-in, or that the data is sensitive?
If the later just post some fake data that is realistic to what you have.

 

[piethein123]

I already have the information. Last time on this forum I at least had a pleasant experience.

 

[Fluff]

I am trying to help you, but I don't understand how your data is laid out. That is why I am asking you to post something.