- 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
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