multiple areas

  1. J

    VLOOKUP for multiple items over differnet sheets

    Hello all I am new here so im sorry if this has been asked and answered but this is what I am looking for.Currently I am using VLOOKUP like this =IF($A8="","",(VLOOKUP($A8,MASTER!$A$1:$G$1500,6,FALSE)))I have changed my master sheet to allow conversions so now I enter the master sheet like...
  2. P

    Vlook using 2 cells to form the criteria

    I work for a city, and what I am attempting to do is use two cells ( that collectively ) make an address, For example in cell one would be the house number 712 and in cell 2 would be the street address 5th st nw. These would correspond to two other cells in a data base to lookup and return some...
  3. FracinDean

    Replacing All Cleared Cells with Default Content

    Hello Forum, I'm trying to use the Worksheet_Change event to replace all cleared cells with a default formula. This allows users to override the default, or restore the default when they need to: If Not Intersect(Target, Range("Data")) Is Nothing And Target.Value = "" Then...

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