Thankyou, I feel so stupid to have missed this, but it works a treat

Thanks again



"arno" wrote:

Hi Ivan,

Is there a way to have this function look at multiple (2
columns) and return a value?

you can add a column to your data that combines the 2 columns just by
eg. formula in A1 =B1&C1. if this formula is in the first column of
your data, vlookup will find it. However, this will only work correctly
if B1&C1 is a unique value.

arno