vlookup alternate pattern

  1. F

    VLOOKUP style Macro to search multiple excel files and return data to a central spreadsheet?

    Hi all, My VBA skills aren't good enough for me to experiment so I'm hoping someone can tell me if the following is possible :confused: In short, I have inherited a large number of excel documents from which I need to collate a report. I can do so manually but obviously I'd prefer it if excel...
  2. D

    Simplify and optimize a complex series of vlookups

    Hi all, I have a bit of an issue and thought this might be a good place to get some ideas. I have a set of data with client ID going vertically down and then horizontally I have the date the client moved to a certain status. I want to know at any given time how many clients are in each...
    • dhsilv2
    • Thread
    • aggregate data performance issue vlookup & if vlookup alternate pattern
    • Replies: 2
    • Forum: Excel Questions
  3. S

    Automatic data alternating per worksheet

    Hi there. I have a workbook which has a worksheet for every day in the month. On each worksheet there is a table which groups, say, cities together according to the country they are in, and each city will have a 1 or a 0 in the right-hand column to determine if that city was covered that day...

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