cri

  1. S

    Merge Table with Input Variable

    I have a query which merge a with another query.. the table which i want to merge is taken from input variable, so the query as given below currently Cri value is POSDATA error is getting when i change the POSDATA to Cri (6th line). How i can put table name in input variable let Cri =...
  2. S

    Index with match specific ranges

    Hi, I am trying to index match the specify type result. Column B4:B18 and C4:C18 contain code and text. Column C had a multiple types are CRI,VRI and RRM. I am looking for specific type (CRI) only.Column E4 match type and F4 code, If matched formula return the text, if not matched formula...
  3. C

    Help Excel Formula - lookup with 3 criteria?

    I have a data table with 6 columns: <tbody> Date Week# Associate Area Promises Hrs 01/01/14 1 Jane North Shore 6 1 01/15/14 3 Ian Aberdeen 5 .5 01/01/14 1 Lewis Aberdeen 2 .25 </tbody> How would you return the "Promises" if the date, associate and area all match the criteria. I...

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