Create list using VLOOKUP and IF?

[Ineedcoffee]

Hi,

I have a list of clients and some of these have been referred to us by other companies. These companies have a unique number allocated.

I want to create a sheet that will 'extrapolate' information about a client based on the referrers unique number.

For example, if there are 10 clients in total and 4 of these have the same referrer number, I want certain client details from Columns A, C, F, I and X come up in a list on a different spreadsheet.

This is basically a filter job, you would get the same results but only with the columns I want to see.

Any help would be greatly appreciated.




Thanks,

Ineedcoffee