Help displaying more than one result of a Vlookup but hiding any N/As.

[Boho Jazz Poet]

Hello,

I was asked to come up with a 'search engine' for a friend and stupidly said yes!

She needed a search engine that when her customer put in a postcode it would bring up all of the companies in a specific area.

I've managed to create a simple format where when the postcode is put into the seach box it'll bring up any matches using a Vlookup but needed help with the it then returning a second, third, fourth (etc.) result.

Is there a bit of code that would do this?

I'm currently using an IF statement to hide any of the errors it finds but I'm stuck with how to display the other results as the Vlookup only returns the first result it finds.

I was thinking there may be a way of using a Countif and another IF statement? Any help would be greatly appreciated!

Work in progress search engine..xlsx

[sktneer]

Try this........

This is an array formula so it needs to be confirmed with Ctrl+Shift+Enter and then drag the formula across and down.

Please Login or Register  to view this content.

Please see the attached sheet.

[Boho Jazz Poet]

Many thanks sktneer!