Return Multiple Values using Vlookup in Excel

[Yaz]

Hey guys,

I have a question.

I have an customers overview. Per customers you can see how much money he/she spend and what order he/she take.

For example:

Customer: Amount: Order:
003 € 250 Magic bullet
003 € 50 Zumba DVD
045 € 250 Magic bullet
112 € 400 Home trainer

I made a Vlookup in another sheet, by just typing the Customer code you´ll see what he/she orded. But I have one problem. If I typ in 003 I just get the first order when im using the formula Vlookup. So the formula just takes the first order and not the second 1.

My question is: Is there a formula to use so i can grab the information from sheet A and by just typing the customer code i get all the information of the customer in sheet B?

Thanks for helping!

PS: sometimes a customer has an order of 3-4 products.

[Don]

Hi and welcome to the forum!

You can certainly do this with formulas in Excel. You will need to use an Array Formula and this will actually not include the vlookup function. This can be a tricky thing to do, especially since it's an array formula, but here is a link to an article that should walk you through what you need to do to get the desired result.

http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx


*updated topic title to reflect your question

[Yaz]

Thank you so much!

I love this forum already