Applying If

[breakdance101]

I Have a sheet (not mine) that applies conditional Formatting based on if the following formula is true:
=AND(Z$28>=$EQ271,Z$28<=$ER271) - Each Cell refence refers to a date and colour the cells (the CF is applied too) Green (basically highlighting the dates items are moving from one department to another)
I would like to add some code that meant that when this condition is met the cells the CF is applied too, completes a Vlookup

so in my head the formula is
if (=AND(Z$28>=$EQ271,Z$28<=$ER271)=TRUE,VlookupA1,Sheetrange,2,false),""

I cannot however apply formula as the cells in question are data input cells

The Cell range this needs to be applied to is

=$AO$272:$AQ$272,$Z$271:$AQ$271,$Z$272:$AM$272,$Z$271:$AD$750,$Z$752:$EN$1152,$AF$271:$AJ$750,$AL$271:$AP$750,$Z$273:$AQ$750,$AR$271:$EN$750

I am very green at VBA but I'm getting used to it.

Any help is appreciated

Thanks

 

[NateSC]

This appears to just be a formula rather than VBA. If that is true, then the following should work:

=if(AND(Z$28>=$EQ271,Z$28<=$ER271),Vlookup(A1,Sheetrange,2),"")

 

[breakdance101]

Thanks - I was hoping to convert this formula to VBA as i can't add formula to the cells

 

[NateSC]

OK. Apologies for my confusion. I'm not clear on exactly where this lookup value will be placed on the sheet. I understand that you cannot paste my formula into the sheet, but if you could, which exact cells would it be placed in?

For a macro, you will need to have a clear definition of the logic. What cells are you looking at to make a decision, where are all the inputs for the Vlookup coming from, where are you placing the result? Since you aren't just copying and pasting like you do with an equation, you have to make the code smart enough to do this. It likely won't be a single equation, but a series of logical steps in order to get the desired result.