Results 1 to 2 of 2

lookup function over even number columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    Dallas Texas
    Posts
    35

    lookup function over even number columns

    I have a work sheet that has names in columns A1-H1.
    I would like a formula that will in effect concatenate the falue in A1-H1 if there is data in the cell directly below it. The problem is that I need to skip every other column. I have the following formula however it will not skip columns.

    =IF(COUNTBLANK(A2:H2)<COLUMNS(A2:H2),LOOKUP(2,1/(A2:H2<>""),A1:H1&" "&A2:H2),"")

    Perhaps this can be done with a lookup function?

    I have attached an example. Please Help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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