Hello,
I am using the partial lookup formula and now I want to darag down and apply formula for all the records but seems like the partial lookup does not working like lookup function and I can't drag down the formula for all the records. Now I'm just wondering is ther any method that I can apply partial lookup function for all the records I have a round 9000 records.
Its the forrmula that I use for partial vlookup and for the other rows I just need to change the lookup_value from A1 to A2..A900
=VLOOKUP("*"&$A$1&"*",$K$1:$L$981,2,FALSE)