Complication in form creation

[rcolving]

I have a form created by a former Administrator in Lotus 123 that I need to recreate in Excel. Sheet 1 is a form for printing. Sheet 2 has input data. On sheet 1 when a Month Ending date is entered in a cell specific data is received from the column in the second sheet that has the corresponding month and year. Sheet 1 actually changes data for each month for data from 5 previous years. I was abel to cut and paste the latest data into excel but of course no formulas. I can provide those if necessary along with the Lotus 123 file.

 

[BrianB]

Perhaps something like this.

Say Sheet 2 has data in range A1:Z50
Lookup values in column A

Sheet 1
Say value entered in cell A1
Lookup formula eg. in B1
=INDEX(Sheet2!A1:Z50,MATCH(A1,Sheet2!A1:A50,0),2)

MATCH() finds the lookup row number
INDEX() uses the row number to get data from column B (=2)

I suggest you look up the functions in Excel help.