| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
