Require data from multiple columns using 2 spreadsheets

[cjg1901]

Hi all

I need your help!

I have 2 spreadsheets in the same file and need to take some data from Sheet 1 into sheet 2 based on 2 columns of critieria:

Sheet 1 contains:
Employee Date Location
Smith John 21/02/2011 London
Doe, John 03/01/2011 Birmingham
Bloggs, Joe 01/02/2011 Manchester


Sheet 2 contains:
Employee Date Location
Smith John 21/02/2011
Bloggs, Joe 01/02/2011

I need to get the data from Sheet 1's Location column into Sheet 2. Looks simple but I can't do it!

Please help asap?

Many thanks
cjg1901

 

[Andrew Poulsom]

Try:

=INDEX(Sheet1!C$2:C$4,MATCH(1,INDEX((Sheet1!A$2:A$4=A2)*(Sheet1!B$2:B$4=B2),),FALSE))

 

[cjg1901]

Thanks but that didn't work - any other ideas?

cjg1901

 

[Andrew Poulsom]

It worked when i tried it. In what way didn't it work for you?

 

[cjg1901]

Hey - it worked in the end, thanks!

Your help was much appreciated

Kind regards
cjg1901