VLOOKUP problem

Report
Posts
225
Registration date
Thursday July 5, 2012
Status
Member
Last seen
January 4, 2021
-
Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
-
Hi !

I have an excel document where I'm trying to use a VLOOKUP formula, however it refers to N#A whereas the value actually is in the column.

If you guys have a moment to look at it it would be awesome !

Here is the file : https://wetransfer.com/downloads/7c6003e23a30e47fb96258bfbf837d7b20201221150747/5520a0

In A2 there is a formula that is working but I wanted to simplify it with a VLOOKUP.
A3 should have the VLOOKUP formula.

Thanks in advance !!

Best regards,

1 reply

Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
454
Hi Farreneit,

If you haven't solved your query yet, could you repost the download link?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!