One formula to populate in multiple cells (possible VBA Code)?

[OlSchool]

Hi Guys,

Not sure if what i'm asking can be done. Please bear with me.

I need a formula that will populate a value based on a 2 conditions.

So basically what i need is the following:

If cell A1= "Yes" and cell B2 has any values from 1 to 6, i need the values from b2 to be populated in C1,D1,E1,F1,G1 and H1.

So if B2=1 i want the 1 populated in C1. If B2=2, i want the 2 populated in D1. If B2=3, i want the 3 populated in E1.

But here's the tricky part. i dont want a formula in cells C1,D1,E1,F1,G1 and H1. I just want 1 formula that will populate to any one of those cells based on B2.

If A1="No", no values should populate.

[AliGW]

To do something like this without formulae in the destination cells, you will need some VBA, I expect. You might want to indicate this in your original thread title to attract the VBA experts.