Double V lookup

[chan_a1]

Is there a way of doing a lookup in 2 cells and return a value where there is a row and column match? For example,

On sheet 1 i have cell B1 = ABC and B2 = 5. The lookup will look up these value in Sheet 2 and return the match. In this case it is $100

Is there a way of doing this?


Sheet 1

A B
1 Product= ABC
2 Users= 5
3 Results= $1000


Sheet 2
A B C D
1 ABC XYZ ONP
2 1 $100 $120 $220
3 2 $200 $130 $320
4 3 $300 $170 $340
5 4 $400 $190 $787
6 5 $1000 $220 $292

Appreciate any help

Thanks
Andrew

 

[chan_a1]

the above statement should have read -

[font='Tahoma','sans-serif']On sheet 1 i have cell B1 = ABC and B2 = 5. The lookup will look up these value in Sheet 2 and return the match. In this case it is $400[/font]