I'm not sure why you're using INDIRECT... Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi, here is an example workbook.
Tables are on the first tab, and I need formulas in cells C2:F4 that will pull those expected values. I need a formula that will be able to lookup the value in B2 and C1 to the corresponding table in A2.
I thought of using an indirect in order to get the actual table name. Let me know if you have any other ideas.
Book3.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks