Vlookup help

[Summer123]

hello,
can someone please tell me how i can display the 2 values chosen by using vlookup, currently i have it so that if you put an X in column at the footer it shows the values listed under column B and C,. But if more then one x is placed in column A then only the first value is shown, what i want to do it show both.. can that be done?

Place an XIDName1Johnx3Bob4Kris6Steph5Mikechosen values3Bobthe vlookup formulas are
=VLOOKUP("x", A2:C6, 2, FALSE)
=VLOOKUP("x", A2:C6, 3, FALSE)

What i am having issues with is if i put an X under both ID, 3 and 4 it should show Chosen Values: 3,4 Bob, Kris

thanks, Summer

 

[namliam]

Vlookup will always pickup the first value that it finds, cant do what you are describing....
You could do something with dynamic ranges perhaps
Or some VBA
Or a simple filter might help you

Sorry

 

[Summer123]

First of all thank you for your quick response. Can you tell me a little bit more on what you mean by dynamic ranges and simple filter?

 

[NBVC]

Can you post a sample workbook, showing your setup and what you require?

It's not easy to tell with your sample in first post.

 

[Summer123]

all set i resolved the issue, u're right though VLOOKUP only takes the first value. I took another route where i concatentated the text and then posted that value. all set. thanks again!