VLOOKUP with multiple criterias

[GWhaA]

Afternoon everyone.
I have been browsing this forum trying to find a formula that can help me display multiple data related to a single reference number. Im a supervisor in a busy distribution center and i have been looking at improving the way i manage my claim data. I want to be able to type in a reference to a claim in a field and display all relating information (I have attached a work book). I can get it working using vlookup but obviously it will only show 1 record, and not multiple records.

It would be greatly appreciated if someone could point me in the right direction. I've seen a few examples on this forum which work with data in 2 columns, but i have been unable to get the formula working in my workbook.

Thank you in advance.

Greg

[ajryan88]

Hi,

The array formula in cell B8 should give you the result that you are looking for. Note that this formula can then be dragged across and down as far as is necessary (which I have already done for you anyway!).

I hope this helps

[ajryan88]

I forgot to mention also, just in case you weren't aware, array formulae need to be entered using Ctrl + Shift + Enter, as opposed to just Enter for a normal formula.

All you should need to do for the formula in the attachment above is adjust the ranges to match your actual data set, and then re-copy the formula across and down.

Let me know

[GWhaA]

You are a legend. Thank you very much ajryan.

[ajryan88]

You're welcome!

Please don't forget to mark this thread as solved (click on Thread Tools above your first post and select Mark As Solved), and please click on the * next to my post to say thanks

Have a great day!

[darby88]

Is that what your look for?