Results 1 to 3 of 3

Comparison formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Queens, NY
    MS-Off Ver
    Excel 2007
    Posts
    17

    Comparison formula

    I am trying to compare data in 3 columns on one sheet to data in 3 columns on another sheet. I am trying several formulas but none is working. an example of what I am trying to do is.
    sheet 1 column A have a emp# and col D have a name and col F have an amount. I need to compare it to sheet 2 to make sure all three of those criteria's match up to what is on sheet 2
    sheet 2 have the emp# in col A, Name in col D and amount in col E.

    Can someon help me with a formula to make this work.

    Thanks
    Last edited by cwallace70; 10-04-2012 at 09:23 AM.

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