JAlandhar 201718
Member
Help me please, I can't understand why I'm getting the error in VLOOKUP formula, If I copy paste the cell value from the table, i get proper result, but if i manually enter i get the "#N/A" error..
VLOOKUP error
- Thread starter JAlandhar 201718
- Start date
AliGW
Well-Known Member
The 'numbers' in the lookup column A are being stored as text, not numbers. If you enter your cursor into cell A5 after the number and then click ENTER, the number will right align and the VLOOKUP will now work. There are two options:
1. Change the text to numbers in the lookup table.
2. Change your formula to this: =VLOOKUP(TEXT($D$3,"00000"),Sheet1!$A$1:$AC$5555,2,FALSE)
1. Change the text to numbers in the lookup table.
2. Change your formula to this: =VLOOKUP(TEXT($D$3,"00000"),Sheet1!$A$1:$AC$5555,2,FALSE)
1] Don't open a new post, and please continue in this original post.
https://chandoo.org/forum/threads/vlookup-error.40085/
2] In the duplicated post, you posted a picture showing that "Ali" has listed in your "Ignored member"
In fact, Ali has replied to your post on the same date, see post no.#2 as in :
3] In according to the Forum rule, your duplicated post has closed.
Regards
Bosco
https://chandoo.org/forum/threads/vlookup-error.40085/
2] In the duplicated post, you posted a picture showing that "Ali" has listed in your "Ignored member"
In fact, Ali has replied to your post on the same date, see post no.#2 as in :
3] In according to the Forum rule, your duplicated post has closed.
Regards
Bosco
