Results 1 to 4 of 4

Lookup table and repeat items corresponding number of times found in table

Threaded View

mellis123 Lookup table and repeat items... 01-26-2011, 04:04 PM
NBVC Re: Lookup Help 01-26-2011, 05:10 PM
mellis123 Re: Lookup table and repeat... 01-27-2011, 09:45 AM
NBVC Re: Lookup table and repeat... 01-27-2011, 10:02 AM
  1. 01-26-2011, 04:04 PM #1
    mellis123 is offline
    Registered User
    Join Date
    01-26-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    8

    Lookup table and repeat items corresponding number of times found in table

    Hi,
    I am trying to create a lookup that looks at the following table:

    Windows Doors Roofs Chimneys
    Building 1 2 4 1 4
    Building 2 9 5 2 8
    Building 3 18 5 1 4


    I want to input into a cell BUILDING 1

    And return the following:

    Window
    Window
    Door
    Door
    Door
    Door
    Roof
    Chimney
    Chimney
    Chimney
    Chimney


    Example attached.
    Any help would be much appreciated!
    Attached Files Attached Files
    Last edited by NBVC; 01-27-2011 at 10:37 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1