ExcelBanter - Looking up multiple cell values

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Looking up multiple cell values (https://www.excelbanter.com/excel-programming/359629-looking-up-multiple-cell-values.html)

Richard

Looking up multiple cell values

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?

Tom Ogilvy

Looking up multiple cell values

=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?

Richard

Looking up multiple cell values

Thank You

"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?

All times are GMT +1. The time now is 06:43 PM.