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.