Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

VLOOKUP problem

Report
Posts
242
Registration date
Thursday July 5, 2012
Status
Member
Last seen
July 30, 2021
 -
Posts
1
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 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,

2 replies

Answer 1 / 2
Posts
2783
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 3, 2021
 469
Hi Farreneit,

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

Best regards,
Trowa
Answer 2 / 2
Posts
1
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 2021
The VLOOKUP function goes through a column to look for the value in the first row and then pulls values down.

To find if there is an N #A rather than a specific value, you may need to use this formula in your spreadsheet:
=IF(AND($C$2="N #A",$C$3<>"#REF!"),NA(),CHOOSE($C$2, "Out of range", "Blank", "Weird"))
You are creating an IF statement that checks both $C$2 and $c3 to see if one does not equal "n/a" or "#REF!" and then it determines what answer you want accordingly.

Excel VLOOKUP is a very useful function if you want to find the value of a spreadsheet in one column by looking for that value in another sheet's column
Here is a helpful resource for understanding how to do this.
https://www.exceltrick.com/formulas_macros/vlookup-in-excel/
Reply Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!