Hi everyone,
I'm just trying to get index match formula to work with VBA.
I have it set up like this
array1 = range of data to return value from, array 2 = lookup array, test = value to look for.
Please Login or Register to view this content.
But when I have it run with indexmatch(a1), I get a #VALUE! error, anyone know how I can get it to work?
Thanks!
Where and how do you define the arrays? Are they Public variables?
Is this suppose to be a User Defined Function used as a formula in a worksheet?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hey AlphaFrog,
I've just chosen two ranges of data down columns as arrays1 and arrays2
Yes, it should ideally be a formula they can just type in a worksheet
Last edited by acho92; 03-12-2018 at 07:37 PM.
I'm not exactly sure what that means?Originally Posted by acho92
What do you mean "chosen" and how does that relate to arrays1 and arrays2? Be very specific please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks