Results 1 to 3 of 3

vlookup multiple tables

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    vlookup multiple tables

    Help please!

    I am trying match data from two columns, from seperate worksheet and where there is a match, populate the columns with data from one of the worksheet to columns on the other.

    With the attached example, on one sheet I have address information (fictitious) and other sheet I have sales information. Where the address number and street address match from the two worksheet, I want to add sale price and sale date in the appropriate column in the address information worksheet.

    I have been trying to do this with multiple, nested vlookups, but without any success. Any help would be very much appreciated!

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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