Jump to content

Excel VBA code for UDF lookup

Enochian
 Share
Posted

Hi Guys, 

Can any of you help me with an UDF for excel? I have made a few but they don't seem to work as i want. Also the first few from "google programming" did not work as expected. 

Basically what i need is a Vlookup formula that will return all the matches - not only the first one that gets found.

I have two workbooks (workbook A - workboob B)   
In workbook A in column B i have my values that i want to use to search in workbook B - they are in column A and B there. 

a normal vlookup would go like this - =VLOOKUP(B2;[Book1.xlsx]Sheet2!$A$5:$B$128;2;FALSE) 

Any suggestions for the UDF to make it find al the matches ?

i7-8086K, Strix Z370E-Gaming, G.Skill Trident 32gb 3000MHZ CL 14, Strix 1080 Ti OC, Corsair HX1000i, Obsidian 1000D, Corsair Hydro X custom loop, 13x Corsair LL120, Corsair Lighting Node Pro, 2x SSD Adata SU800 3DNand - 1tb and 128gb, 1Tb WD Blue, Cable Mod Full Cable Kit, Monitor Asus XG27VQ 144Mhz Curved

Link to comment
https://linustechtips.com/topic/990044-excel-vba-code-for-udf-lookup/
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×