Returning one value based on 2 criteria's and 2 data sets

[JWSafe]

I've admitted defeat with this one....
I'm trying to return the value from the E Column from the right hand side spreadsheet - to column J on the left hand side.
But column G (left) needs to find column B (right) and column E (left) to column A (right) and then return the value in E (right) to column J(left).

thats my attempt formula.

Cheers

 

[6StringJazzer]

The logic in that formula isn't correct for what you want to do. (Just for the record, your VLOOKUP is invalid, but it's not even reaching it. You are using range B:E with a column number of 5, but there are only 4 columns in that range.)
I'm not going to retype everything from a picture but use the full file name here:

=IFERROR(INDEX([R.csv]Sheet6!$E:$E,MATCH(E2 & G2,[R.csv]Sheet6!$A:$A & [R.csv]Sheet6!$B:$B,0)),"na")

I didn't set up two files to test this but I have used it before. It is an array formula. You won't have to do anything special in 365 to enter it.

 

[SunnyAlv]

Try This

its like lookup by 2 Criteria

=INDEX([Rountines_Level_Project.csv]Sheet6!E:E,MATCH(1,(G2=[Rountines_Level_Project.csv]Sheet6!B:B)*(E2=[Rountines_Level_Project.csv]Sheet6!A:A),0))

 

[JWSafe]

Try This

its like lookup by 2 Criteria

=INDEX([Rountines_Level_Project.csv]Sheet6!E:E,MATCH(1,(G2=[Rountines_Level_Project.csv]Sheet6!B:B)*(E2=[Rountines_Level_Project.csv]Sheet6!A:A),0))

worked perfectly thank you