Type mismatch in arguments when I try to call a function

[FZappa]

Hi all. I wrote a function that I believe will be able to put out a value from a fairly complex table based on the values of three of its columns. This is said function

Please Login or Register  to view this content.

Now I think the function is likely to work, but since I'm standing on the shoulders of giants here, I'm working with a lot of stuff I've never used before, so to test it out I wrote the very simple call sub below:

Please Login or Register  to view this content.

The error I'm getting right of the bat is "Type mismatch" and the argument where the range goes is highlighted. I'd love it if someone could fix the problem, but more importantly, is this the correct way to call said function? I'm having a hard time figuring out based on the resources I've looked up.

I've attached a sample workbook if it helps.

[CK76]

Few issues here.

1. You should either use Err# instead of xlErrNA. Or define constant value for xlErrNA at start.
xlErrNA = 2042

2. The function should not be defined as returning Long. As you want to return error value (from use of xlErrNA)
Use As Variant.

3. Altrura should also be variant.

4. "A6:L34" is string, you need to qualify it with sheet and range object.
I.E. Sheet1.Range("A6:L34")

5. Col is declared as Integer. So don't use double quote. When a number is nested in double quote, it's implicitly treated as string.

Also, you were missing "." at end of Fecha value.

So, something like below would work.

Please Login or Register  to view this content.

FYI - You really wouldn't need UDF for this. INDEX/IF() Array function, or INDEX/Aggregate combo should be able to handle it.

[FZappa]

Oh man, thanks so much for that. I knew I had to be making some basic errors like that, I'm still finding the basic logic of excel a bit overwhelming. It works now!

[CK76]

You are welcome and thanks for the rep