Problem with Excel worksheet function always defaulting to the false conditional

Can somebody figure out what is wr开发者_StackOverflowong with my Excel formula?

 =IF(vdnh.rpt!$B:$B=B$1,VLOOKUP($A3,vdnh.rpt!$A$21:$L$34,6),"-")

It is not working and it keeps giving me "-" answer.

It doesn't work because you can't ask for the range to equal one cell, unless maybe you try an array formula. Just go the cell that formula is in, and then hit CTRL-SHIFT-ENTER, and see if it works then.

vdnh.rpt!$B:$B=B$1 is false (the value in B1 does not match the value of the cell that is in column B in the same row as the formula) so the false part of your IF statement "-" is being shown.