Excel Excel - Vlookup returns blank rows between between data

Joined
Jun 23, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top