VLOOKUP problem

Report
Posts
259
Registration date
Thursday July 5, 2012
Status
Member
Last seen
November 26, 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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Farreneit,

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

Best regards,
Trowa
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/