index match multiple unique values based on one criteria

This one has me confused because I cant put these in a list, they have to go to the right up to 3 columns.

In column A I have a list of customers
In column B I have a list of appointments

In column E I have a list of Unique Appointment numbers
In column F,G, and H I basically want to transpose the unique customers next to their respective Appointment numbers

I can do this easily if i make a list but trying to work from left to right in multiple columns has me perplexed.

I need a formula to copy down in columns F,G, and H

I have provided examples in the upload of what the data should look like.

Many thanks.

Sorry about that,

In cell F2 I need a formula that uses cell E2 as the criteria and finds the FIRST unique customer from column A
In cell G2 I need a formula that uses cell E2 as the criteria and finds the SECOND unique customer from column A(provided there is one)
In cell H2 I need a formula that uses cell E2 as the criteria and finds the THIRD unique customer from column A(provided there is one)

Not all appointments will have 3 customers, some can have 2 or just 1.

Formula in cell E2 (Customer 1 of Appt No 1):

Please Login or Register  to view this content.

Drag and fill to other cells

Originally Posted by lazyme

Formula in cell E2 (Customer 1 of Appt No 1):

Please Login or Register  to view this content.

Drag and fill to other cells

Column E is my criteria, the formula should start in cell F2. Not sure if the formula can be dragged down because I feel it also need to be dragged to the right to fill columns G and H