Oct 11 2021 05:24 PM
Oct 11 2021 06:35 PM
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)......
Oct 12 2021 06:24 AM
@mathetes
thank you,
please see attached.
Oct 12 2021 11:03 AM
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.