Hi,
Please check the attached file.
I am basically trying to make an index-match function to dynamically refer to ranges.
Thank you
Hi,
Please check the attached file.
I am basically trying to make an index-match function to dynamically refer to ranges.
Thank you
Please * if you like the answer
Can you give an more specific example? I cant quite tell what you are trying to accomplish.
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 then scroll down to Manage Attachments to open the upload window.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
index($b$4:$j$37,,match(L4,$b$3:$j$3,0))Please Login or Register to view this content.
just returns the column that matches the year in column L
Last edited by protonLeah; 12-29-2016 at 05:53 PM.
Ben Van Johnson
@mikeTRON - I'm afraid I've done exactly what you've suggested
@protonLeah - Thanks a lot for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks