Speed up the task of a VLOOKUP on a large database

[@rocky20717]

Thank you Sir, i dont have a powerquery in my office...What other formula i can use?

[@excelenthusiasts]

None that i am aware of.

[@rocky20717]

Thanks

[@sravanipogiri4680]

Sir I didn't get all values but some values like N/A what mistake I did in it

[@excelenthusiasts]

I cannot say. I will need to see your file.

[@Shivaayprogamer]

I want to say thanks sir it a great

[@excelenthusiasts]

You are welcome.

[@jaswantdn7]

Thank You so much sir.

[@excelenthusiasts]

You are welcome.