Hi - I want to perform a lookup of two columns of data. ie if both colums match their test data, then return the value in the third colum of the lookup table.

what is the best formula to use?

many thanks