formulas find search

  1. A

    Lookup values based on which days are selected

    This is hard to explain but I have set numbers, that need to be changed based on the days of the week that are selected. This would be the given part of my sheet. Example 1 Col A B C D E F J Row 1 Sun Mon Tues Wed Thurs Fri...
  2. O

    Index Match and returning the *right* value

    I have a spreadsheet that is used as a resource planner and I am trying to plot who is working on what in a graphical format (bit like within Project Server - but that's a whole other conversation). The data is set up as below and I want to return the project name where the value is e.g. Bob...
  3. R

    Problem With Excel Time Sheet Formula

    I have searched High & Low for this answer and am getting nowhere! Does anyone know the formulas for the following: in cell E4 I have 29:36 Mins (Standard Working Week Hrs) Below I have the following Formulas for automatically working out Flexi Up or Down (This is not the problem) In cell...
  4. X

    Formula to recognize words in a cell & return a value from a different cell

    I have a sheet with data. There are rows labeled direct labor, other costs, etc. Thes are located in column A. Then in column G there is data. Id like a formula to do such ex Find the word direct labor in column A on the sheet, & return the value in column G to a summary sheet. is this possible?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top