Problem with Excel worksheet function always defaulting to the false conditional

Question

Can somebody figure out what is wrong 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.

Answer 1

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.