INDEXed Items in price list

Hi there

I've attached an example spreadsheet. I have a price list spreadsheet listing about 5000 items. What I want to do in a new sheet is type in the keyword and below that it lists all cells with that keyword. Can anyone help me please?

Hi,

Check this with he help of Helper Column

Punnam

Hi thanks

WHere do i find that?

WHere do i find that?

Not clear what your asking for

Punnam

Not sure why mine isn't working

I've substituted into your formula:

=IFERROR(INDEX(Pricelist!$A$1:$A$5000,SMALL(IF(Pricelist!$H$1:$H$5000="YES",ROW(Pricelist!$A$1:$A$5000),""),ROW(3:3))),"")

and I just get a blank?

Observation Required

1) Update "price List" with he if condition
2) after placing the placing the above formula in "find"Sheet of cell A4 you should use the combination of the following keys to activate the Array function
"Ctrl+Shift+Enter"
3) Do you have data in "Price List" from Row 1
4) as it is a array function it will take more time to calculate
5) In case of higher version of excel instead of "," you should use ";"
Punnam

Punnam

How do I attach another file?

Go to Advance tab from there in tool box you will "attachment " image

Punnam

OK thanks, here's a more accurate version of the s/sheet I'm trying to do

I'm using Excel 2010 and there are 5000 rows altogether in my spreadsheet

Hi,

Find the attached updated file

Punnam

Thanks so much, when I change the keyword, how do I get it to calculate again?

NVRensburg

Just type the desired keyword , rest will be done automatically .

Punnam

Thanks Punnam, however you've got SOUP as the keyword but it's not returning the correct items?

Thanks so much Punnam! I can't thank you enough for all your help today! You've been an absolute star!!!!!

Hi Nvrenburg,

Thanks for the Rep & Feedback.

punnam