Calculations using VBA custom function w/ provided data

[kboyd757]

I have datasets concerning 3 categories: vegetable seed, temperature, and germination temperature.

I want to write a custom function using EXCEL VBA that lets a user input a single vegetable type (using a drop box, preferably) from a given list along with a temperature provided by the user. Once these two factors are entered, I want the macro to pull information from another dataset (individual germination temperature for each vegetable) and calculate two outcomes: germination rate & days to germination.
These outputs can be triggered using buttons or what have you and presented on any cell in the worksheet.

Stuck writing the function and really NEED HELP!
Much thanks,

[Richard Buttrey]

Why do you need a UDF?

Seems to me that standard Excel functions will achieve this without needing to re-invent the wheel.

[kboyd757]

A function would work, but a UDF is required for what I am trying to do.

[kelleytr]

Can you provide us the data sets? Maybe upload them in an .xlsx?

[kboyd757]

Here is the dataset regarding the germination rates

[kelleytr]

Thanks, it appears that the second data set isn't consistent with the first data set.

For example, "Beans, snap" versus " Bean, snap" notice the differences are a space and the letter "s".

There are also more vegetables in the second data set than the first, 37 to 24, was this intended?

Can you normalize the data into one table? Or at least make the two tables keys analogous so that I can combine them into one table via a VLOOKUP.

Once we have the data ready we can begin working on the function.

[Richard Buttrey]

A function would work, but a UDF is required for what I am trying to do.

Why?

UDFs are always slower than inbuilt functions. What possible advanatage can you secure by using one? Or is this a homework question?

[kboyd757]

kelleytr:

I have further consolidated the data into a simpler pair of datasets.

THANKS

[kelleytr]

Thanks kboyd757,

I believe I made what you are looking for. Take a look at the attachment and let me know if that works.

[kboyd757]

That's just what I was looking for, kelleytr. Thanks for all the help, well done!