Help with If Statement populating several Cells

What about a macro then?
In this example, it would be done 45 times, but with a twist. If its blank, then the other cells in B,C,D, and E columns would also stay blank.

That solved it.

Now I have a more real world scenario that I'm working on that adds unfortunately 1 more layer of complexity.

A3 may also equal 1-4, BUT for the scenario that A2 has either a 1, 2, 3, or a 4, then the hyperlinks keep on adding up.

Ex:
A2 = 3, THEREFORE B2, C2, and D2 have hyperlinks called widget(1), widget(2), and widget(3). (That part was solved, thanks to FDibbins).
A3 = 4, THEREFORE B3, C3, D3, and E3 should have hyperlinks widget(4), widget(5), widget(6), and widget(7).

OR
A2 = 1 & A3=2,
THEREFORE B2 should have hyperlink widget(1)
and B3, C3, and D3 should have hyperlinks widget(2), widget(3), and widget(4).

The only way that this scenario would work, where A2 and A3 would keep on counting up the (#)'s is because Z2 = Z3 = widget

IF Z2= Widget, and Z3= Fidget, and Z4= Midget, then post #4 works perfectly.

Can the column B, C, D, and E formulas be modified for this scenario?

how so?

I never fully understood what indirect does (I did do my research to find out what it does, but I don't get what it's supposed to do. That's why I didn't immediately respond to your post. I was researching what it is and its use).

FDbbins, how can I use hyperlinking and indirect for the examples I have on Post #5?

Never mind, I got the last part of the question answered here:

http://www.excelforum.com/excel-form...hyperlink.html