Please forgive if this is a simple thing. I am VERY new to Excel VBA as most of my previous VBA work has been in Access. My problem is as follows:

I have a form with two combo boxes They are populated with the X and Y values of a hidden table/worksheet. Depending on the selected X and Y values, I would like to look-up the corresponding table value (in the hidden worksheet) and place this 'looked-up' value in a cell.

If I am unclear in my explanation, please let me know. Any help is always greatly appreciated.

Thanks,
Nick

If you're looking for a simple solution. There is a vlookup function in Excel. You can use this to reference a range and return the value from a specified field even from a different file.