Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    7

    Unanswered: Comparing 2 columns of data and returning values?

    Hi All,

    I am stumped on this one.

    I have a spreadsheet of about 550 servers that have attributes such as server name, warranty expiry date etc.

    In another spreadsheet I have a list of about 400 servers that a user requires the warranty information for.

    Is there a way to have excel compare the list of 400 hundred servers to the list of 550 servers and return the warranty expiry date column for only the 400 required servers? I am hoping to not have to do this manually.

    Any suggestions are appreciated.

    Jon

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi Jon,

    Sure, next to the list of 400 servers, you can pull in the warranty expiry dates using VLOOKUP().

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •