Vlookup with IF statement pulling back multiple columns

[Chasedward]

Hi I have an excel workbook with multiple worksheets. The Pole Sheet has column A where there is either Yes and No. I need to pull any row with a Yes into another worksheet, but only certain cells from the Column B, E, X and Y I have looked at doing IF VLOOKUPs, but I have nothing to lookup in the worksheet I am attempting to bring the data into.

 

[maabadi]

Please Upload your example file with XL2BB ADDIN (Preferable) or Upload at free Hosting site e.g. www.dropbox.com or GoogleDrive or OneDrive and Insert link here.
Are you have problem with VBA?

 

[Fluff]

How about

=FILTER(FILTER(Sheet1!B2:Y100,sheet1!B2:B100="Yes"),(COLUMN(Sheet1!B2:Y2)=1)+(COLUMN(Sheet1!B2:Y2)=4)+(COLUMN(Sheet1!B2:Y2)>23))

 

[Chasedward]

How about

=FILTER(FILTER(Sheet1!B2:Y100,sheet1!B2:B100="Yes"),(COLUMN(Sheet1!B2:Y2)=1)+(COLUMN(Sheet1!B2:Y2)=4)+(COLUMN(Sheet1!B2:Y2)>23))

Hello thank you for your response. I will take a look at this in the morning. Have been working since 4am today so am a little tired now.

 

[Fluff]

Ok, that's fine

 

[Chasedward]

Please Upload your example file with XL2BB ADDIN (Preferable) or Upload at free Hosting site e.g. www.dropbox.com or GoogleDrive or OneDrive and Insert link here.
Are you have problem with VBA?

Hi thank you. I will upload an example file in the morning. Have been working since 4am today so am a little tired.