robmarr700
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just managed to download file and the cell is indeed formatted to text as suggested.
ASKER
Well done Rob,
Just the answer I was looking for.
Thanks
Rob
Just the answer I was looking for.
Thanks
Rob