VLOOKUP problem

Question

VLOOKUP problem

Report

farreneit

Posts: 225
Registration date: Thursday July 5, 2012
Status: Member
Last seen: January 4, 2021

- Dec 21, 2020 at 10:09 AM
TrowaD

Posts: 2717
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 1, 2021

- Jan 5, 2021 at 11:24 AM

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,

VLOOKUP problem
Vlookup entire workbook ✓ - Forum - Excel
Excel - VLOOKUP to filter rows based on numbers - How-To - Excel
How to combine columns using Vlookup? - How-To - Office Software
Stop #N/A appearing after a vlookup ✓ - Forum - Office Software
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel

1 reply

Reply Ask a question

TrowaD · Answer 1 · 2021-01-05T11:24:50-0500

Answer 1 / 1

TrowaD

Posts: 2717
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 1, 2021

459
Jan 5, 2021 at 11:24 AM

Hi Farreneit,

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

Best regards,
Trowa

VLOOKUP problem

1 reply

Your reply

Subscribe To Our Newsletter!