It depends on how static the target data is and if it is in a table. The simplest way would be to have a helper column and concatenate the two key/searched fields (with &). You can then concatenate the search items and do a simple VLOOKUP. The advantage of the data being in a table is that the concatenated help field will be maintained automatically.


Regards, TMS