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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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