d12

1. VBA Code - Amend to include more references

Hi there, Can anyone help me amend this VBA code to include more than one reference (if possible)? It currently refers only to D12 but I want to add another nine references - D68, D124, D180, D236, D292, D348, D404, D460 and D516. Thank you! Private Sub Worksheet_Change(ByVal Target As...
2. Alternative Formula

Good evening, Would it be possible to have an alternative formula to the following as this only returns data if D12 is a alpha numeric value =IFERROR(LOOKUP(2,1/(Data!\$AK\$3:\$AK\$502=D12)/(Data!\$AD\$3:\$AD\$502=F12),(Data!\$X\$3:\$X\$502)),"") this matched D12 within AK3:AK502 and F12 within AD3:AD502...
3. #VALUE! error

I am using the below formula for a sales calculator in my organization and am getting a #VALUE ! error. Once I fill in D12 the error goes away, but if D12 is blank, the error is there. I'm sure it's a IFERROR I need to put in the formula, but not sure where to enter and compete the formula to...
4. SUM based on an Array Criteria That is In A Different Cell

I have a SUM IF formula that looks like this (there are additional sumifs criteria but removed them to keep example short) =SUMIFS('Data Pull'!\$K\$12:\$K\$24363,'Data Pull'!\$C\$12:\$C\$24363, \$D12) Where D12 contains 51* Thus it only sums accounts that start with 51. I later wanted to to do the...

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.

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

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