formula help

[Tim105]

I have an amortization table on a spreadsheet. On a seperate spreadsheet I
would like to write a formula that will look up data from the amortization
spreadsheet based on a typed-in payment number.

 

[Gary''s Student]

See VLOOKUP in Excel Help.

 

[Don Guillett]

Easily done. Look in the help index for VLOOKUP.

 

[dlw]

look up help on the vlookup command, using =<sheetname>!<range> to reference
the other sheet.