Forum Discussion
2 way Xlookup multiple sheets with list
Ex
A1 is the list of sheets,
Colum b
Rev
Direct costs
Sga
Edit
Row A
Jan-sept
Sheets
Different areas
Calgary
Edmonton
Vancouver
Toronto ect..
3 Replies
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
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.
