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.


    Code
    {=IFERROR(INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A:$A"),A4)>0),0)),"0")}

    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
    [/SIZE]

Participate now!

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