If value false, look in next cell

[cburgin]

Hi,

I want a formula that will look in a table, and return a value if a condition is met, and if the condition is not met, searches for the next entry that fulfills the criteria. For example, if an entry is classed under "Pizza", I want it to pull through the details of the pizza, "Topping", "Base", "Price". If the entry is not classified under "Pizza", I want it to look for the next "Pizza" entry and enter it in the row. I want to do this with no blank rows, as potentially there may be thousands of entries and need a concise list that just summarises "Pizza" entries.

Is there a way to do this without macros?

Thanks.

 

[jamot1]

Hi cburgin,

It's difficult to provide an answer not knowing the layout of the data.

Have you tried to sort the data? If you're looking more formula based solution, I'd try the '=IF()' formula. It allows you to test a condition and it will provide results based on whether the test is true or false.

Thanks,
Thomas

 

[Christian Burgin]

Hi Thomas,

Thanks for your reply. I've got an answer at the moment, which involves the indirect function to find rows with a certain fulfilled criterion. Not sure if it is the most straightforward way, but it works for me.

Thanks for your reply.

 

[Michael M]

As Thomas mentioned, it's difficult to solve without the layout....
but, you could also consider looking at the VLOOKUP function for extracting matching data
AND
maybe a VBA solution would be simpler......but layout is a 1st requirement...