Not working range within nested function

[Sara895]

Hi,

I have a problem when add concatenate and Vlookup in the formula, it doesn't work. Before adding them the function was working right.

When I drag to row 3,4,5,etc, the ranges A2 and M2 didn't change regarding to the row number to be A3,A4,... and M3,M4,... 

Hereunder the function for more clarification:

=VLOOKUP(CONCATENATE(,INDEX(Gender,MATCH(1,COUNTIF(A2,"*"&Gender&"*"),0),0),M2),N:O,2,FALSE)

Thanks in advance 

[#2]

@Sara895 

I see no problems with the formula

What exactly doesn't work?

I'd only remove third parameter (zero) for INDEX and wrap it by IFNA, but that's cosmetic.

[#3]

Thanks, it's working now.