Results 1 to 8 of 8

VLOOKUP / ISNUMBER / SUMIF Stumped, can't get formula to run

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    CT
    MS-Off Ver
    Excel 2007
    Posts
    3

    VLOOKUP / ISNUMBER / SUMIF Stumped, can't get formula to run

    I am stumped. I can do a VLOOKUP - been using excel since the Lotus 1-2-3 days. I am usually pretty resourceful with formulas, googled, picked another intermediate users brain and I can't get a formula to work.

    I am matching the number in sheet 1, column A to sheet 2 column A and if they match I need to then populate information from sheet 2 column C into sheet 1 column B

    Can anyone assist with a formula? I've tried is number, match, sumif...you name it! I can't get anything to run without errors. I feel like a dunce! I'm usually able to get through complicated formulas. Ugh!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by abbyalana; 11-29-2012 at 04:58 PM. Reason: Solved

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