Forum Discussion
Solved
What formula should I use?
I need help setting up a formula that will be able to pull in the correct column of data from a separate tab when the date is changed. I am unsure which formula to use to get my desired result. I hav...
Sorry I think the 2nd photo got cut off
t3r
as for attaching files, there is some restrictions on new accounts so instead you can post it in sharepoint/onedrive and share a link or in dropbox or the like.
As for your issue, I would suggest using the new FILTER function to filter the column you need based on the value entered on that sheet. You mentioned you tried index-match combo, which should work as well as variations of lookup, hlookup, xlookup.
if you can't get a link to work you can PM a sample sheet and I can demonstrate how that could work in your case.
As for your issue, I would suggest using the new FILTER function to filter the column you need based on the value entered on that sheet. You mentioned you tried index-match combo, which should work as well as variations of lookup, hlookup, xlookup.
if you can't get a link to work you can PM a sample sheet and I can demonstrate how that could work in your case.