VLOOKUP with Condition

[anelem]

Hi
Sheet 1 :
Col A Col B Col C
Row1 Joe Green 45100
Row2 Joe Red 30000
Row3 Joe Blue 15000
Row4 Sag Green 2077
Row5 Sag Red 31001
Row6 Sag Blue 45000

Sheet 2 :
Col A Col B Col C
Row1 Joe Green ?
Row2 Joe Red ?
Row3 Sag Blue ?
Row4 Sag Green ?

Looking to get answer in Sheet 2 Col C
So Sheet 2 Col A must match to Sheet 1 Col A
When found, Lookup Sheet 2 B1 on Sheet 1 Col B
When found, return contents in Col C

Hope I have explained this well.
If anyone can please assist will make my job easier for me.
Thanking you in advance

 

[etaf]

cool , thanks @Fluff

 

[Fluff]

You're welcome

 

[jasonb75]

If you want to use a lookup / array method then why not use one that doesn't need a delimiter to prevent false matches?

=LOOKUP(2,1/(Sheet1!A$2:A$8=A2)/(Sheet1!B$2:B$8,B2),Sheet1!C$2:C$8)

Although, as I mentioned earlier, sumifs should work fine based on the example provided, eliminating the need for any arrays entirely.

 

[Fluff]

I agree that with sample the OP provided sumifs would be a better option, as for the index/match approach, I just prefer it.