Vlookup with Conditional IF statement

[vancoservices]

Hey everyone,

I'm hoping you can help me out with this problem. I'm trying to do an if statement that has 2 conditions and if those are met, then perform a vlookup. Here is what I have so far:

=if((A2:A100=G2)*(B2:B100=H2),vlookup(something on a different sheet),0)

I get a return of all 0's and I know that they shouldn't all come back with the 0's. Any suggestions on my formula or suggestions for a new formula?

I also tried =if(AND(A2:A100=G2,B2:B100=H2),vlookup(something on a different sheet),0) but that didn't work either.

Please help!