if & match

  1. TheMacroNoob

    Search Multiple Sheets for Conditional Values

    Hello Excel Experts, I have a potentially novel request: I have 22 sheets with the exact same formatting/cell positions. I would like to grab values from all sheets that meet criteria. If Column C contains "Yes" on any sheet, I would like the sheet name (contained in cell A1), the Building...
    • TheMacroNoob
    • Thread
    • 3-d formula array if & match lookup multiple sheets in excel small / dynamic range
    • Replies: 1
    • Forum: Excel Questions
  2. U

    VBA: Code to skip or ignore rule If Cell data is not Identical

    Hi Gurus, Good day! I just wanted to ask for your insight as I found a code to merge accounts, however if the cell data is not the same, it will skip the code. Example: No Name Data 1 Data 2 001 Math 100 95 002 Math 100 95 003 Science 95 90 'VBA Code for Merging the Data 1 and...
    • unknownymous
    • Thread
    • if & match if statement and and or macro vba & conditions vba & excel
    • Replies: 7
    • Forum: Excel Questions
  3. D

    Check if a value exists in 2 columns and return true/false

    I'm trying to make a formula that checks if a code exists in 2 existent columns, if it exists in BOTH, it returns a text, that part works perfectly, I used If, And, Match for it. But when i tried to get the other half, when it exists in only one of both (X-Or) it returns error, because of the...
  4. G

    If yes on workbook 1 than yes on workbook 2 for same title.

    Hi there, I am developing a Master Project Tracking workbook for an architectural firm which will pull data from other workbooks and summarize them. The first task I have to figure out is as follows: If we have a Project titled Kim's House in Column B (Project Name) in the Master Project...
  5. N

    Circular reference from a IF,Match formula

    Hi guys Trying to get a formula to work, and failing....again! So I've got this far and can't understand why its not working, did tests as I went along, but now it's coming up with a result of '0' Dunno why? The Formula is as follows Excel Formula...

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