=vlookup("house",sheet2!A:B,2,False)*10 + vlookup("car",Sheet2!A:B,2,False)*1.3

--
Regards,
Tom Ogilvy


"Richard" wrote:

Hi,
I would like to lookup multiple cell values on one spreadsheet; perform
operations on each cell, add those numbers together and paste the results
into a cell on another sheet. Is there a formula that can do thatf?