vlookup error

[JAlandhar 201718]

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..
my previous post also got ignored.
please let me know the reason, i didn't crossed rules and regulation nor i talked rude to anyone

 

[pecoflyer]

First get rid of merged cells D3,E3 and F3 and put your value in D3 only
Your values in col A sheet 1 are text, that in sheet 2 D3 is a number
You can try something like=VLOOKUP(TEXT($D$3,"#####"),Sheet1!$A$1:$AC$5555,13,0) to find your values

Stay away form merged cells, worst feature Excel has. Instead try " center across selection" to format and have the same effect

 

[JAlandhar 201718]

First get rid of merged cells D3,E3 and F3 and put your value in D3 only
Your values in col A sheet 1 are text, that in sheet 2 D3 is a number
You can try something like=VLOOKUP(TEXT($D$3,"#####"),Sheet1!$A$1:$AC$5555,13,0) to find your values

Stay away form merged cells, worst feature Excel has. Instead try " center across selection" to format and have the same effect

Thanks alot sir

 

[bosco_yip]

Duplicated post

1] Don't open a new post, and please follow your original post.

2] Ali has replied to your post on the same date, but you ignored to her post, please see :

https://chandoo.org/forum/threads/vlookup-error.40043/



In your post #.1 picture showing that 1 person gave reply - "Ignored member" and the "Ignored member" is Ali.

3] This post closed

Regards
Bosco