+ Reply to Thread
Results 1 to 2 of 2

Comparing lists - Need Help

  1. #1
    Registered User
    Join Date
    Madison, NC
    MS-Off Ver
    Excel 2007

    Comparing lists - Need Help

    We generate daily updated work lists. What I need to do is take a job number from today's list (for example we'll call it Tab 2 cell A2) and compare it to yesterday's work list.

    Tab 1 = yesterday
    Tab 2 = Today

    What I want is if Tab 2 Cell A2 appears anywhere on Tab 1 then print the notes from tab 1 (column J for that corresponding row) onto Tab 2 cell J2

    I don't even know where to start. I tried but got nowhere with if/then logic.

    Please help

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    Midlands, UK
    MS-Off Ver
    Excel 2019/365

    Re: Comparing lists - Need Help

    If you can upload an example spreadsheet with false data and an expected output manually typed in to explain in more detail we can make sure that we provide an accurate solution.

    In the meantime try:

    =VLOOKUP(A2,'TAB 1'!A:J,10,0)

    This assumes that Tab 1 has the data in the range A:J where Col A holds the same value as A2 (or should do if it exists).
    Say thanks, click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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