I am currently using vlookup to put together a summary sheet. However, I
would like to Look up Column A and B, and then return the corresponding
Column C figure. For example:

John Brown 6
John Green 5
John Black 7

If Forename is Column A, Surname is Colume B and Column C is the value I
need to return to the summary sheet. I'm not sure how to lookup more than
one column?

Any ideas??????