Vlookup with IF statement pulling back multiple columns

Chasedward

New Member
Joined
Dec 16, 2020
Messages
5
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,583
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,327
Office Version
  1. 365
Platform
  1. Windows
How about
Excel Formula:
=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

New Member
Joined
Dec 16, 2020
Messages
5
Office Version
  1. 365
Platform
  1. Windows
How about
Excel Formula:
=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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,327
Office Version
  1. 365
Platform
  1. Windows
Ok, that's fine (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,141
Messages
5,622,969
Members
415,943
Latest member
JakeG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top