Multiple look ups

[bboy]

Hi All,

I am really stuck on a formula,

Basically on sheet 1 i have the headers Agent (a1) Date (a2) in sheet two i have the headers date (a1), agent (a2), name (a3), rank (a4), score (a5)

So what i want is to check the agent name and date on sheet one and return the score of the agent from sheet two with the same name and date

can any one help?

 

[steve the fish]

You need to be clearer. What is 'agent' and what is 'name'? So what is 'agent name'?