VLOOKUP problem
Report
farreneit
zacharyswift727
- Posts
- 259
- Registration date
- Thursday July 5, 2012
- Status
- Member
- Last seen
- November 26, 2021
zacharyswift727
- Posts
- 1
- Registration date
- Thursday July 29, 2021
- Status
- Member
- Last seen
- August 4, 2021
Related:
- VLOOKUP problem
- Vlookup entire workbook ✓ - Forum - Excel
- Vlookup date 1/0/1900 ✓ - Forum - Excel
- Excel - VLOOKUP to filter rows based on numbers - How-To - Excel
- Transfer data from one excel worksheet to another automatically vlookup - How-To - Excel
- How to make vlookup column index change - How-To - Excel
2 replies
TrowaD
- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
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 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/
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/
