Match function

Hi everyone,

I need some help with the match function. I have attached a spreadsheet with has the following:

1. on the left hand side is the data we have collected
2. on the right hand side is where we need the match data to work ie under the column F with a1, we need the have all the data from the left hand side that matches a1 to be listed here, etc for all the other columns after. Hope that makes sense. If you need to ask me any more detail, just let me know. Thanks in advance for your help.

Try this,

F3

Please Login or Register  to view this content.

committed with Ctrl+Shift+Enter, then copied down.

You can also see attached.
Hope this helps,
windknife

Hi,

Thanks heaps for your help, works great. Greatly appreciated.

Cheers