I'm trying to create a VBA function which will do a VLOOKUP using 3 criteria on an Excel table and return a value.
I've attached a test workbook (no VBA code yet) with the lookup table and 3 dropdown cells which provide the input for the VLOOKUP function. On the change of any one of the dropdown cells, the function should return a result depending on the values in the dropdowns.
Not sure where to start with this.
Thanks in anticipation