# VLOOKUP problem

Closed
farreneit Posts 282 Registration date Thursday July 5, 2012 Status Member Last seen January 13, 2023 - Dec 21, 2020 at 10:09 AM
zacharyswift727 Posts 1 Registration date Thursday July 29, 2021 Status Member Last seen August 4, 2021 - Aug 4, 2021 at 11:35 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 !

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

Best regards,

## 2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 5, 2021 at 11:24 AM
Hi Farreneit,

Best regards,
Trowa
zacharyswift727 Posts 1 Registration date Thursday July 29, 2021 Status Member Last seen August 4, 2021
Updated on Aug 4, 2021 at 11:37 AM
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/