VLOOKUP HELP

[AMORGAN723]

Hello

I am trying to preform a VLOOKUP looking at 2 different values between sheets before giving me the "true" value and I can't figure it out.

Example 

Sheet 1

ITEM                LOT                    QTY

APPLES               1                         4

APPLES                2                       6

Sheet 2 

ITEM               LOT                      QTY

APPLE                 1                         ##

**I am trying to make it look at Sheet 1 and determine which Item and then look at lot # to give me the QTY

Can anyone please help with this??

Thank you!                

[#2]

@AMORGAN723 

VLOOKUP cannot look up in two columns.

Alternatives:

=SUMIFS('Sheet 1'!$C$2:$C$1000, 'Sheet 1'!$A$2:$A$1000, A2, 'Sheet 1'!$B$2:$B$1000, B2)

or

=INDEX('Sheet 1'!$C$2:$C$1000, MATCH(1, INDEX(('Sheet 1'!$A$2:$A$1000=A2)*('Sheet 1'!$B$2:$B$1000=B2),), 0))