[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

V lookup Errors!?

Hi,

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.

Rob
Vlookup-error-EE.xlsx
0
robmarr700
Asked:
robmarr700
  • 2
1 Solution
 
Rob HensonIT & Database AssistantCommented:
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.

Thanks
Rob H
0
 
Rob HensonIT & Database AssistantCommented:
Just managed to download file and the cell is indeed formatted to text as suggested.
0
 
robmarr700Author Commented:
Well done Rob,

Just the answer I was looking for.

Thanks
Rob
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now