Return multiple values for one data point

Hello! I've had a excel situation at work that I can't seem to figure out what to do, so I was hoping this forum could help! I know how to use vlookup and it is close to what I need done, but since it only returns the 1st value it isn't quite what I need. I need a formula that will return multiple values.

I'm comparing two large lists of accounts and their charges to make sure each list has the same data. So if account ABC123 had 3 charges ($1, $5, $10 in a column in that order) I want to be able to run formula from one list to the other that shows all of the charges for each account. If I run vlookup, it would only show the 1st charge (in this case $1) for the ABC123 account every time. I would like to be able to run a formula so it lists whatever the next charge is.

Anyone have any ideas?

Thanks for your time!

Hey thanks for your response! I've tried using the index formula combined with others but get really confused with it so I haven't gotten very far. I will take a look at what I'm working on Monday and upload a sample workbook that evening so I can give you a better idea of what I'm trying to do

Thanks again

Hi all,

Attached is a sample of the data I'm working with. I have briefly looked at the suggestions from the previous posts, but I haven't had a chance to test any of it with my data.

Thanks again for taking a look

Book1.xlsx

Yayyy! Thank you so much, Tony!!