Results 1 to 15 of 15

VLOOKUP is returning the "title" of my column in the correct cells.

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2011
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    7

    Unhappy VLOOKUP is returning the "title" of my column in the correct cells.

    Hi! New to all of this, and even Excel programming. I recently learned how to use the VLOOKUP formula and love it. I mainly use it at work to help with billing. However, I'm getting stuck, and need help. Basically, all of my VLOOKUP formulas work, except for this one. I have my "Description" and "Prices" in columns A and B. The VLOOKUP formula seems to be finding the Descriptions fine, but instead of returning a price, it will literally return the word "Price" as a value. Maybe I'm not describing the issue thoroughly, again, I'm new to this. Can somebody please help me and let me know what I'm doing wrong?

    Also, on one tab, I have my worksheet with the VLOOKUP formula. Where I want it to start, then the table array which is on the second tab, I enter 2 for the column, and true, since I want a sort of match. On tab two, where I have the "Description" and "Prices", there is a formula to come up with the price, something like =(C2*D2+7.25) Could that be the problem? Also, there is text and numbers in tab 1 vs tab 2, only has numbers. I want VLOOKUP to find the NDC numbers, and give me the price (derived from the formula).

    :
    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