Results 1 to 15 of 15

Excel 2007 : Function to enter data in 2 columns and get data in 3rd Column automatically

Threaded View

  1. #13
    Registered User
    Join Date
    05-20-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Function to enter data in 2 columns and get data in 3rd Column automatically

    Hi Dilip, The following is my requirement: A function has to be inserted in $C$18 so that ...

    If I type ' Office ' in $A$18 and I type ' 2003 ' in $B$18, then $C$18 will automatically dispaly ' 6700 '.

    Again, If I type ' Office ' in $A$18 and I type ' 2007 ' in $B$18, then $C$18 will automatically display ' 9000 ' .

    The SUMIFS() function suggested by Cutter is working absolutely fine, but we have so far covered the following functions-

    IF() , AND(), OR(), NOT(), COUNT(), VLOOKUP(), HLOOKUP(), SUM(), SUMIF(), COUNTBLANK().
    Last edited by somali.cc; 05-21-2012 at 04:55 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