Forum Discussion
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 ...
mathetes
thank you,
please see attached.
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.