searchfor

  1. H

    Search Left

    Hi - I'm using this code as a vlookup. Is there a way to alter the code so that i'm only looking up the first 3 digits of the value in Column 6 on Sheet6? Dim LastRow, LR1, LR2, LR3, i As LongDim Searchfor, j, inarr As Variant Set wsRS = Sheet6 Set wsDT = Sheet2 With wsDT LastRow =...
  2. H

    VBA Array instead of Vlookup

    Hi, This is making me nuts. I have directions and still can't make this work. I'm trying to replace this calc: Vlookup(V3,Worksheet!$G$4:$J$10,4,0) So want to lookup the value in row V of sheet2, the lookup range is on worksheet G4:J10. If sheet2 column V = worksheet column G, then place...
  3. H

    VBA Lookup/Filter

    Looking to interpret how exactly this works? I love using it, but i really don't know how it works and how i would manipulate it to work in other scenarios? Set ws3= ThisWorkbook.Worksheets("Sheet3") Set ws1 = ThisWorkbook.Worksheets("Sheet1") Dim lastrow, lastrow2, i As Long Dim Searchfor...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top