two cell criteria

  1. A

    Look up similarities

    <tbody> KIT 1 KIT 2 KIT 3 KIT 4 APPLES ORANGES APPLES LIMES BANANAS WATERMELON LEMONS ORANGES ORANGES ORANGES WATERMELON </tbody> Lets say I have these kits. I would like to write a macro that allows me to search through all kits and return the kit names that have certain (multiple)...
    • alfordtp
    • Thread
    • macro search a table two cell criteria two critera
    • Replies: 0
    • Forum: Excel Questions
  2. M

    Search for, and extract data

    ​ <tbody> A B C D E F G H I 1 TODAY'S DATE: WITH/WITHOUT PAY: DATE EMPLOYEE LEAVING DATE EMPLOYEE RETURNING WITH OR WITHOUT PAY 2 11-9-2015 10-30-2015 11-2-2015 WITH 3 11-7-2015 11-14-2015 WITHOUT 4 12-25-2015 12-26-2015 BIRTHDAY PAY...
    • MIKEBIZ
    • Thread
    • date and range extract data from cell two cell criteria value between dates value extarctiom
    • Replies: 10
    • Forum: Excel Questions
  3. L

    VLOOKUP based on multiple criteria, one is age range

    Hey, I have a bit of a problem, I need a formula to look something up based on two variables. So the info that will be input is Name, Group and Age, eg. Name: John Group: Blue Age: 40 Member Price: I need it to draw the member price based on the group and age; <tbody> Group Age Range...
    • lemony
    • Thread
    • index array match two cell criteria vlookup vlookup index match
    • Replies: 3
    • Forum: Excel Questions
  4. E

    Fill in values based on 2 column criteria

    Hi Guys, Im struggling to find a formula to populate cells based on values to be checked in two fields (ICODE, COMPANY). In the example shown, all records where ever the ICODE = 49, i need to populate the fields AD1,AD2,AD3 or AD4 with the Product Name of the same company name but only where...

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