Results 1 to 11 of 11

vlookup with random gaps in rows (hard to explain see attached sheet!)

Threaded View

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    17

    vlookup with random gaps in rows (hard to explain see attached sheet!)

    Hi

    I have a sheet (attached) where data is put into columns J, K, L and M. This is in sets which can vary from one to six rows and it is random as to how many rows each set will have. I need to transfer the values over to columns A, B, C and D but the problem is that A, B, C and D are fixed at six rows each in order to accommodate the maximum number of rows each set can have (I cannot change this). How do I get the data from J, K, L & M into A, B, C & D? I have tried various vlookups but it cannot account for the random placing of the gaps in the sets.

    The sheet attached shows how it would look with the data transferred. Can anyone help with a suitable formula to do this please.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-19-2017, 05:46 PM
  2. Replies: 7
    Last Post: 12-08-2014, 09:05 PM
  3. [SOLVED] Hard to explain, please help
    By FooFighter616 in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 02:20 PM
  4. Hard to explain question
    By odditie in forum Excel General
    Replies: 4
    Last Post: 02-16-2007, 05:09 PM
  5. [SOLVED] Help with spread sheet (Hard to explain)
    By facebuddies in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-08-2006, 11:04 AM
  6. Please help!!! This is hard to explain!
    By Robert Sadler in forum Excel General
    Replies: 4
    Last Post: 02-02-2005, 12:28 AM
  7. Please help!!! This is hard to explain!
    By Robert Sadler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2005, 05:48 PM

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