ifs if

  1. R

    Can't Get Formula To Work

    I'm trying to get a formula to work but really struggling. What i need is a formula for a cell to auto populate with text based on a letter in another cell. For Example, if Cell B3 reads Rob then Cell E3 populates with Robert, but if cell B3 reads Sam then E3 populates with Sammy also if B3...
  2. N

    Marco, IFS and XLOOKUP but certainly happy to be wrong

    I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...
  3. J

    how to compare values from multiple columns from other sheet?

    Sub numbers() Dim rngCell As Range For Each rngCell In Sheets("Final").Range("F13:F" & rowLast) If WorksheetFunction.CountIf(Sheets("Filter").Range("A1:A" & rowLast), rngCell) <> 0 And _ Range("I" & rngCell.Row).Value <= 0 And _ Range("D" & rngCell.Row).Value < 50 Or _...
    • jaik22
    • Thread
    • comparing 4 columns dynamic cell lookup filter array data columns ifs if rngcell
    • Replies: 0
    • Forum: Excel Questions
  4. S

    Copy date for specific job Number

    <tbody> No. Date Job. No. 1 3/5/2016 456 2 4/5/2016 454 3 5/5/2016 455 4 6/5/2016 457 </tbody> 2nd Sheet <tbody> Job. No. Date 454 455 456 457 </tbody> I want to copy cell value from date column of 1st sheet if another cell in same row have "sample" value

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