+ Reply to Thread
Results 1 to 2 of 2

Need a formula please

  1. 02-08-2007, 10:46 PM #1
    paulfitz320
    paulfitz320 is offline
    Registered User
    Join Date
    02-28-2004
    Posts
    4

    Need a formula please

    How can I make A1 and B1 search through columns D and E until it finds the same values as in A1 and B1 and then return the value in the adjacent cell E1

    Thanks
    Attached Images Attached Images
    Last edited by paulfitz320; 02-08-2007 at 11:06 PM.
    Reply With QuoteRegister To Reply
  2. 02-08-2007, 11:40 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    If there is only going to be one match then try

    =sumproduct(--(d2:d23=a1),--(e2:e23=b1),(f2:f23))


    rylo
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1