V lookup Errors!?

Posted on 2014-09-01
Last Modified: 2014-09-01

Can any one explain why my vlookup in cell B28421 insn't returning the correct value (PVR Direct Limited).

Instead it is just displaying the formula. When I hit enter I am not getting the desired result?

See attached.

Question by:robmarr700
    LVL 31

    Accepted Solution

    One simple option that may be worth checking, what is the format of the cell containing the formula?

    If it is text, the formula will show as text and not calculate. Change to General and then re-enter the formula; or Press F2 go to beginning of formula and delete the apostrophe if it is there, press enter.

    Rob H
    LVL 31

    Expert Comment

    by:Rob Henson
    Just managed to download file and the cell is indeed formatted to text as suggested.

    Author Comment

    Well done Rob,

    Just the answer I was looking for.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now