macro_user
Board Regular
- Joined
- Mar 9, 2009
- Messages
- 101
hi,
i am trying to use VLOOKUP to populate a cell's value. I noticed that i get different types of error fields populated when a value is wrong/not found. Can someone explain to me the reasons why we get these different types of error fields:
#N/A
#NAME?
#REF?
=VLOOKUP(B2,F:G,2,FALSE)
in the 4th case, Im sure that a value is present in the column where i am looking in but the formula doesn't seem to have gotten executed. It just displays the formula the same way.
Appreciate the help.
Thanks!
i am trying to use VLOOKUP to populate a cell's value. I noticed that i get different types of error fields populated when a value is wrong/not found. Can someone explain to me the reasons why we get these different types of error fields:
#N/A
#NAME?
#REF?
=VLOOKUP(B2,F:G,2,FALSE)
in the 4th case, Im sure that a value is present in the column where i am looking in but the formula doesn't seem to have gotten executed. It just displays the formula the same way.
Appreciate the help.
Thanks!
Last edited: