conditional if with vlookup

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?

Any help would be awesome, thanks

Perhaps using AND(cond_1,cond_2) would be appropriate.

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

Using the AND function inside didn't work, I am getting the same results.