Results 1 to 3 of 3

collecting results from data tab - vllokup ?

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    34

    Wink collecting results from data tab - vllokup ?

    I am trying to match data on one tab to another so that the data downloaded from another source is sorted into a specific order for presentation perposes

    I have tried using a vlookup but im not sure if that is the correct solution

    ie on the attached I have a data tab that is a download of jobs by cost centre and this comes in from another source - on the results tab I am trying to pick up this data again to show in a specif order - I do not want to just point to the coresponding cell in the data tab as the real data is huge over 3000 lines each day
    I want if possible to lookup the data in the data tab and post to the correct cell in the results tab

    ie on the results tab C4 should return 25 jobs for the 1st March which it would read from the data sheet in volumn b6

    appreciate any help with this i seem to be going round in circles and not confinced vlookup is the answer

    thanks

    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