Hello - in the attached sheet, I am looking for a formula in column F that will return results that correspond with the “ticker” in column A and “period” in column B and display the data from the same ticker (tab 2, column A, and period (tab 2, row 1) in the second tab.
Any ideas? Thanks!
F2 =INDEX(Results!$A$1:$L$3,MATCH($A2,Results!$A$1:$A$3,0),MATCH($B2,Results!$A$1:$L$1,0))
remove the space behind cell B2 (and below).
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks