I am wanting to use the lookup function to insert a particular value from a
list in another worksheet in the same workbook eg.

If data in A1 & B1 are present then lookup the other worksheet to find both
data values from A1 & B1 and then return the value in column C of the 2nd
worksheet