formula help
 

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.

formula help
 

See VLOOKUP in Excel Help.
--
Gary''s Student - gsnu200807


"Tim105" wrote:

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.

formula help
 

Easily done. Look in the help index for VLOOKUP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tim105" wrote in message
...
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.

formula help
 

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

"Tim105" wrote:

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.