Results 1 to 6 of 6

IF functionality issues

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2010
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2007
    Posts
    54

    IF functionality issues

    Hey guys, I am a novice excel user who is trying to learn and apply the functionality of the IF function. For this project I am working on, I would like to have data from sheet one which is highlighted in the attached doc. pulled and sorted into sheet 2 when a user inputs a certain criteria in the cells A2 to D2.What I am thinking is that there will be a drop down tab for each criteria with all the information from the table. The user will select policy prefix and coverage and fill in the date. I personally am not sure if the drop down tab is the best way of doing this so I’m open to suggestions. From there after all that information is plugged in the criteria on sheet 2 from cells A12 to A15 will be filled in automatically with the corresponding information from sheet one data. Pretty much this is to short allot of data later and just want to get the processes started of how this would work. I believe the IF function would work to process the desired results to be filled in from A12 to A15 but I just can figure out how to set the formula or if it is even the correct way of doing this. Please send and suggestions or help. I’m just a intern trying to make this project work and any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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