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.  

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
byundt

8/22/2022 - Mon
Pratima

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
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy