Complication in form creation

rcolving

Board Regular
Joined
May 23, 2002
Messages
122
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,983
Messages
5,767,438
Members
425,413
Latest member
ccfam04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top