Help with formula

[Pottie8]

Hi All

Below is my sheet. I need the item name from sheet INFO (if ticked, column D says true) to display in INFORMATION sheet.

https://drive.google.com/file/d/0B9p...ew?usp=sharing

Any help would be greatly appreaciated!


Regards,
Pottie8

 

[rahulshewale1]

Hii,

is this your looking for ......


Thanks
Rahul shewale

 

[Luke M]

Hi Pottie8, and welcome to the forum!

You might want to check out the article I wrote about making such a list:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

Formula would be something like

=IFERROR(INDEX(Info!A:A, SMALL(IF(Info!D$1:$D$100=TRUE, ROW(D$1:D$100)), ROWS(A$1:A1))), "")

Remember to confirm as an array using Ctrl+Shift+Enter, not just Enter.

 

[Pottie8]

WOW Guys! Thank you so much for the prompt response!!!

 

[Pottie8]

Working 100% Thank you!