Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Drag Down the partial vlookup formula in excel

0

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)

Answer
Discuss

Discussion

Hi Naz and welcome to the Forum

I'm not clear on your question or the nature of you data (since you didn't attach a file). Your VLOOKUP will deliver a value just for the first exact (partial) match it finds (and that could be in the second column of your search range if a match is found in column K). Do you want several values to be returned?

Please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. Then we should be able to give specific help.
John_Ru (rep: 6102) Oct 19, '22 at 6:43 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login