Results 1 to 4 of 4

Formula Help

Threaded View

ringrim Formula Help 06-26-2008, 11:30 AM
NBVC First, It seems the... 06-26-2008, 11:38 AM
ringrim That worked great. Is... 06-26-2008, 11:51 AM
NBVC copy it down. Select cell... 06-26-2008, 12:14 PM
  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    22

    Formula Help

    Good Morning,

    Am having a bit of trouble coming up with the correct formula here at work. I am new to Excel Formulas and am hoping someone can help. I have attached my workbook that has 2 sheets. In worksheet Totals i have column F titled CPT. I need a formula that will match the values from each cell in column F to my worksheet titled CPT using column 1. If the match is found, return the value from worksheet CPT column 2. I thought this would be easy but my following formula isnt correct. Can anyone help me out?

    =INDEX(CPT!$a$5:$a$511,MATCH($f$8,CPT!$b5:$b$511,0),2)

    Thanks
    Attached Files Attached Files

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