Excel - Vlookup returns blank rows between between data

Nice1chicl · Nice1chicl's Computer Specifications

Hi

Can someone please help. I am a newbie to vlookups

I have a problem with my vlookup formula. I have two work sheets 1 x main sheet and 1 x customer sheet. In total i have 16 columns. The P column (16) has data validation of 'yes' & 'no'. What i am trying to do is display all columns/rows that are 'yes' on my customer sheet. The formula below works, but it also inserts blank rows where P column (16) = 'no'. This means that i have to filter out the blanks. I don't want to send to a customer like that.

=IF(VLOOKUP($A3,Main!$A$3:$P$22,16,0)="Yes",VLOOKUP($A3,Main!$A$3:$P$22,COLUMN(),0),"")

Thanks in advance

Michelle

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Vlookup returns #N/A when Range is 'false', but returns valueswhen 'true'	Pete_UK	Microsoft Excel Worksheet Functions	1	8th Mar 2010 03:36 PM
How do I delete blank rows (rows alternate data, blank, data, etc	=?Utf-8?B?bmNvY2hyYXg=?=	Microsoft Excel Misc	2	27th Jun 2007 04:40 AM
select block of rows w/data between blank rows	=?Utf-8?B?SmFubmE=?=	Microsoft Excel Programming	6	13th Feb 2005 03:45 AM
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP(	=?Utf-8?B?T3Nv?=	Microsoft Excel Worksheet Functions	2	26th Jan 2005 07:56 AM
Inserting blank rows between data rows (mutliple at one time)	DP	Microsoft Excel Misc	2	21st Oct 2003 06:21 PM