Results 1 to 9 of 9

Help with If Statement populating several Cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    256

    Question Help with If Statement populating several Cells

    Column A lists how many links should be created... a number from 1 through 4.
    Columns B, C, D, and E correspond to those 4 photo links.

    How do I set up a formula such that, if...

    A2 = 1, then B2 will create a hyperlink
    A2 = 2, then B2, and C2 will create a hyperlink
    A2 = 3, then B2, C2, and D2 will create a hyperlink
    A2 = 4, then B2, C2, D2, and E2 will create a hyperlink

    I do know how to create a hyperlink in a cell, so I don't need help with that.
    In which cell would I put in the formula? F2?
    I was thinking that a vlookup would help, but it would populate B2, C2, D2, and E2 when populating those cells is conditional based on what A2 will show (either a 1, 2, 3, or 4).
    Last edited by JPWRana; 06-24-2013 at 09:14 PM. Reason: A1=1 Should have been A2=2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1