Hi guys,

This is my first post and I'm looking for some help with a vlookup function from 2 columns.

I have sheet1 with the columns;

sales date
sales person
sales number


In sheet2 I want a function that looks up the "sales number" based on "sales date" and "sales person".

Is it possible to have 2 vlookup criteria in one function?

Many many thanks!

Adrian