Search an array for a value, and once it's found, concatenate other data from the row

General question that I should absolutely be able to solve, but am having a very difficult time. Basically, I have a numerical list of months 1 - 60 on Sheet 1. I would also like to have in a cell directly above the numerical month, the Text of the month, what fiscal quarter it corresponds to, and the fiscal year. I've manually input the FY data on a seperate sheet along with the numerical value that will be the common key, but am trying to come up with a formula that I can search the array on my data sheet to find "1", then be able to concatenate the other colums to display " January, Q2 FY 15"

For my data sheet Column A is the Month, B is the numerical month value, C is the Quarter, and D is the Fiscal Year, so on my display sheet, I have cells in row 2 containing 1-60, and want row 1 to index to column B in the data sheet, and concatenate A, C, and D.

I hope this is descriptive enough; any help would certainly be most appreciated. Happy New Year everyone!

para

I'm sure it can be done, but it's difficult to visualize your setup.

Can you post a sample book?
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

It will need to be continually updated, so that's why I'm trying to develop some semblance of autonomy in the workbook. For example, if the next document implements in April, April will be month 1 as opposed to March in this document. I can just renumber the data tab to reflect April as the implementation month, and the display sheet will recalculate.

I've attached a document, and the highlighted area represents what I am trying to have excel do automatically. Thank you both for your help!

-paradime

It would be easiest if you do the concatenation on the Data Page.
In E2 on the Data page and filled down
=A2&" "&C2&" "&D2

Then in A1 on the Display page and filled right
=INDEX(Data!$E:$E,A2+1)

EFParadime.xlsx

Many thanks Jonmo, as typical, I was making it harder than it actually should have been.

I hope you have a great New Years.

You're welcome.