Results 1 to 32 of 32

VLOOKUP Multiple Lines

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2009
    Location
    Kilmallock, Rep. of Ireland
    MS-Off Ver
    Excel 2003
    Posts
    21

    VLOOKUP Multiple Lines

    Hi, i am working on a project & I am having difficulty with extracting multiple data from one worksheet to another, Basically, if the Cell "C2" is equal to lets say "Tesco", I am looking for all the Tesco Data from the download data to show in the Template Worksheet, & then similarly if "c2" is pressed for "Sainsburys", i want the sainsburys data to show in the template.
    Is this possible?

    What I have at the minute is being only able to get 1 line of data out, but will have much more than that & different qtys of lines for each "Supplier"

    I have attached a data file to easier understand what I mean

    Cheers
    Jonny
    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