Vlookup across multiple worksheets and list sheet names

  • Hello,

    I use this array formula to reveal sheetname if lookup value found in one of the sheets.


    The problem is that, This formula finds and displays the sheet name where first occurrence of value found. For instance, value A150 is found in Sheet2. However, the same value also exists in the Sheet3. I also want to display other sheet name where lookup value found. Any advice would be great.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke

  • Hello Onexc,

    Hope you are doing fine ... (long time ...)

    Just stumbled upon your post ... which reminded me of the code written by Chip PEARSON to determine if a sheet exists ... or not

    Hope this could help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!