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..
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..