#hlookup

  1. Jyggalag

    Track when new sheets are added to an Excel file

    Hi all, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...
    • Jyggalag
    • Thread
    • #hlookup easy excel fast formula =and() help copy and paste indexmatch jonas sværke macro vba vlookup & if & and xlookup
    • Replies: 6
    • Forum: Excel Questions
  2. D

    Searching is not giving desired result

    https://app.box.com/s/wrtv64g0fx4o0gexeott0ba12j1ykd0g https://drive.google.com/open?id=0B1GJKIl2o1WZam5HZ25oRGo5TTA Cell F38 should show .3798 in stead of 5 Cell F39 should show .4899 in stead of .8880 Cell F40 should show .5769 in stead of 1.3130 Can anyone explain
    • dxzaber
    • Thread
    • #hlookup #matching #searching #searching #vlookup
    • Replies: 3
    • Forum: Excel Questions
  3. D

    Vlookup Hlookup is not giving desired result

    https://drive.google.com/open?id=0B1GJKIl2o1WZb0RJODV0ak9QQnc Password: cfc47& Cell F38 should show .3798 in stead of 5 Cell F39 should show .4899 in stead of .8880 Cell F40 should show .5769 in stead of 1.3130 Can anyone explain
  4. E

    Index / Match

    I am trying to use Index Match to pull data totals into a summary sheet. On the detail sheet, I have rows of orders (Order 1,2,3...), the columns have monthly Dates (Jan-15,Feb-15,Mar-15...). Each month with each order has a payments. In the summary sheet I want to put a formula that will...

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