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
zacharyswift727 Posts 1 Registration date Thursday July 29, 2021 Status Member Last seen August 4, 2021 - Aug 4, 2021 at 11:35 AM
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 5, 2021 at 11:24 AM
Jan 5, 2021 at 11:24 AM
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
Updated on Aug 4, 2021 at 11:37 AM
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/
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/
