Results 1 to 12 of 12

Need a formula to make Excel search for info

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need a formula to make Excel search for info

    Please help! This would save me HOURS AND HOURS of work!

    I need a formula to make Excel search columns C-E (all rows) of worksheet 1 for data contained in columns A-C of worksheet 2. If matching data is found, I want it to insert the data from column J worksheet 2 (same row as A-C) into column G of worksheet 1. I need to be able to apply the formula to each row, columns will remain the same.

    Is this possible? I hope it makes sense, this is WAY beyond my Excel knowledge!

    See attached for the worksheets.

    Thanks in advance!

    Melissa
    Attached Files Attached Files
    Last edited by Memzzie; 10-14-2011 at 07:51 AM. Reason: SOLVED

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