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.