broken

  1. C

    constantly re-linking workbook files

    New to '07, but am adjusting fairly well until this: I've got an issue with keeping links linked. I made 25ish workbooks with links to common files that everyone in the department has access to. When one of these 25 files is opened for the first time of the day for each user, a pop-up appears...
  2. R

    Edit Links window is mostly gray

    I'm using Excel 2007. I have 2 files: http://rstr.us/e/stm-m.xlsm and http://rstr.us/e/stm-b.xlsm The first contains links to the second, but using a different name. When I open the first and go to SourceAttributes sheet, I see in D22 a real link and the cell shows the linked cell's value...
  3. J

    Custom VBA VLookup Formula

    I'm having a hard time getting a custom vlookup formula to work. I need to be able to change a part of the range in the vlookup dynamically based on a cell value. This is what I came up with but it gives me a value error. Can anyone help? Function VL(val As Variant, RNG As Range, col As...
    • jOSEFFB
    • Thread
    • broken custom function dynamic lookup vba vlookup
    • Replies: 3
    • Forum: Excel Questions

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