more than 4 conditions

  1. P

    Vlookup function with Match in more than four different tables array

    Hy I have got a problem to ask and here it is.. I am using more than four tables data each have a unique id no i am using this formula =VLOOKUP($B3,CHOOSE(VLOOKUP($A3,$D$2:$E$5,2),BBuilding,CBuilding,DBuilding,CABuilding),7,0) Now the problem is i have (suppose) A11 cell selected to show me the...
  2. A

    VBA for CF for 6 conditions in Excel2003

    Hello guys, I got a VBA code from this forum long time back for CF in 2003. But I needed to change it and when I did it stopped working. Now I am stuck again with no clue how to write it. The conditions I need are: If A1="OFF", then font is bold & black and cell colour is light green If...

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