Link to home
Start Free TrialLog in
Avatar of SquigglyMonkey
SquigglyMonkey

asked on

Excel help with formula/search

I have a workbook with multiple worksheets (monthly expenses)

I want the first worksheet to be yearly totals. But, I'd like at least part of those totals be from some indivdual things like each utility. So..... Is there a formula that can search all worksheets for a the word Electricity and get the value of the cell adjacent to it?

I tihnk I just need one example and i'll be on my way.  

Avatar of Pratima
Pratima
Flag of India image

if I understand it correctly you are looking for this

have a look on below 

https://exceljet.net/formula/search-multiple-worksheets-for-value
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial