VLOOKUP problem
Closed
farreneit
Posts
274
Registration date
Thursday 5 July 2012
Status
Member
Last seen
13 January 2023
-
21 Dec 2020 à 10:09
zacharyswift727 Posts 1 Registration date Thursday 29 July 2021 Status Member Last seen 4 August 2021 - 4 Aug 2021 à 11:35
zacharyswift727 Posts 1 Registration date Thursday 29 July 2021 Status Member Last seen 4 August 2021 - 4 Aug 2021 à 11:35
Related:
- VLOOKUP problem
- Iserror function in excel with vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Vlookup compare two columns and return a third - Excel Forum
- How to use vlookup to match data from different sheets - Office Software Forum
- Vlookup with condidion - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
5 Jan 2021 à 11:24
5 Jan 2021 à 11:24
Hi Farreneit,
If you haven't solved your query yet, could you repost the download link?
Best regards,
Trowa
If you haven't solved your query yet, could you repost the download link?
Best regards,
Trowa
zacharyswift727
Posts
1
Registration date
Thursday 29 July 2021
Status
Member
Last seen
4 August 2021
4 Aug 2021 à 11:35
4 Aug 2021 à 11:35
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/
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/
