Struggle with select case, index and match code in a UDF.

[-Citizen]

Hi,

So I made a user defined function which is suppose to help me look up some values in a table. The thing is, the function has three options, so I start out with "select case".

The code is as follows (the sheet names and ranges are simplified to not confuse people).

Please Login or Register  to view this content.

I just get "Value" in the cell where I place the code. I have no idea what can be wrong.

Any help is highly appreciated!

[WideBoyDixon]

You don't need the Range("") around Value1 for sure and you probably don't need it around Name1 either (unless Name1 is a reference to a range like "S6"). So I would *guess* something like this where I took out the repeated use of Worksheets("Sheet1"):

Please Login or Register  to view this content.

WBD

[-Citizen]

You don't need the Range("") around Value1 for sure and you probably don't need it around Name1 either (unless Name1 is a reference to a range like "S6"). So I would *guess* something like this where I took out the repeated use of Worksheets("Sheet1"):

Please Login or Register  to view this content.

WBD

Thank you my friend! That worked as a charm!