Forum Discussion

Ntratechaud's avatar
Ntratechaud
Copper Contributor
Oct 12, 2021

2 way Xlookup multiple sheets with list

Hi I'm lookining to do a two way lookup across multiple sheets using the list function. Ex A1 is the list of sheets, Colum b Rev Direct costs Sga Edit Row A Jan-sept Sheets Different areas ...
excel
mathetes's avatar
mathetes
Gold Contributor
Oct 12, 2021

Ntratechaud 

 

You've had quite a few "views" of this inquiry and as of this writing no replies. I suspect the reason is that it's not really clear what you're trying to do.

 

Do you have a workbook that you've created in which you're trying to do this "two-way lookup"? So long as it contains no confidential or proprietary info, posting that workbook would be of far more value, to any of us that might be able to help, than a verbal description, and I mean the actual workbook (not just an image)......

    • mathetes's avatar
      mathetes
      Gold Contributor
      Oct 12, 2021

      Ntratechaud 

       

      The INDIRECT function will serve you better. Here's the formula I entered into cell D4.

      =INDIRECT($A$2&"!"&D$1&$A4)

       

      The full file is attached. Here, though, is an image showing how it works when copied to all the adjacent cells. Notice the little "helpers" I entered in the top row and the side column. Those could be hidden in a fully functional workbook; they're visible here just for learning purposes.

       

Resources