index match ?

I have search the board, but when you don't know exactly what you are searching for, it's really hard to find it


Currently I have an index match statement that works well... but now I need something similar to an index match that matches two items then returns a value from a cell in the same row

Sheet 1

ID Name Getinfo1 Getinfo2
1 person1
2 person2


Sheet2
ID Name code info1
1 Person1 bbb 200
3 person3 aaa 125
1 person1 aaa 326
2 person2 aaa 589
5 person5 aaa 56
2 person2 bbb 567
5 person5 bbb 125
4 person4 aaa 894


in Getinfo1 column I need to match a person by ID and by code 'aaa', if matches return value in info1 on sheet two

in Getinfo2 Column I need to match a person by ID and code 'bbb', if matches return value in info1 on sheet two

this is not identical to the setup I have but the setup is actually too large to reflect here... Sheet two is random with no particular sorting as is sheet 1.

thanks in advance for looking at this..