Excel search function across multiple tabs

Hi guys,

I have attached a simplified version of a workbook

I am looking to search by client details (using a wildcard), this works fine, but I need it to cover the wholeworkbook and all the tab.s Is there anyone who can help me with my formula?

See the Jan tab, cell H1: =HYPERLINK("#'Jan'!A"&MATCH(G1&"*",A:A,0),"Go!")


Thank you!

R.

Just reading around online and I`m unsure if I should be seeking to integrate something like this
Vlookup($b5,indirect("'"&c$4&"'!"&"b5:c11"),2,0)

Your description doesn't really tell me WHAT you want the formula to return. Is it one result? Multiple results? Can you amend your sample to show represenative desired results?

Hi Glenn,

Basically, here is what I`m trying to achieve:

Typing in the JAN tab, cell G1, I am hoping that I am able taken through (with the hyperlink) to each result in multiple tabs (basically like a control F function). The tabs will be months (Jan, Feb, Mar) and so on.

The list of clients will vary in terms of order across the tabs, i.e. Argos might be in cell A1 one month then A2, the next month. The column will remain unchanged.

I hope this helps clarify my issue!

Thank you

Did you mean

Please Login or Register  to view this content.

But this formula offer only goto same tab >_<

Regards.

Hi menem

Sadly this as you said works for one tab, not the whole workbook

Also it looks like I can't use the wildcard (*) or like functionality too...

If you allow me to use helper columns .... no helper sheet.

Please review in the file.

It's only use INDIRECT , MATCH but use move cells for generate reference table in 'Sheet1'
I can not explain well, if you see directly in D column you can see the different of each cells.

Regards.