Create list using VLOOKUP and IF?

Ineedcoffee · #1 12-05-2011, 03:57 AM

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

Pecoflyer · #2 12-05-2011, 04:17 AM

Hi
maybe post a sample sheet with "before" and "after"

Ineedcoffee · #3 12-05-2011, 04:43 AM

Hi,

I have attached what I am after.

Thanks,

Ineedcoffee

macropod · #4 12-06-2011, 01:38 AM

Hi Ineedcoffee,

See the solutions I've posted at:
http://lounge.windowssecrets.com/ind...owtopic=771787
http://www.techsupportforum.com/micr...la-issues.html

Ineedcoffee · #5 12-06-2011, 01:49 AM

Hi Macropod,

Spot on, thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a distribution list?	Emerogork	Outlook	2	08-25-2011 09:04 PM
how to create a distribution list from emails	GibsonGK55	Outlook	3	08-19-2011 12:22 PM
create tree list in excel sheet	chuikingman	Excel	5	06-27-2011 09:38 AM
Create Drop Down List Box	hbradshaw	Word VBA	0	09-27-2010 06:24 AM
How do you create a list similar to an itunes list?	hatemail13	Excel	1	08-06-2010 02:21 AM