Hi,
i'm currently working on a formula using INDEX/MATCH in order for me
to match 2 criterias based on date (manual input on print sheet), this
would be based on a master list (Master Sheet), however the formula
i'm using is showing me "N/A" value :-(.
Master -> Master List
TS -> Print Sheet Criteria: Date
I have attached a file (sample), thanks in advance.
Diego
close, try this array...
=INDEX(Master!$A:$A,MATCH(TS!$B$1&TS!$A4,Master!B:B&Master!C:C,0),1)
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Absolutely Perfect.
Thanks Mr. Dibbins,
Diego
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks