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
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

×