im doing some spread sheets to do with accounting and im stuck on a formular. i think i have to use SUMIF or such however i cant find exactly which. i want basicly a hot key sort of thing. for example if you type in 'title A' i want it to show information from an entirly different cell that is perhaps even on a different sheet. if anyone knows what i need to do thanks for the help, x