vlookup or index/match?

[cloughie]

Hi,

I have two sheets of orders from different sources and want to check if the gross price is the same for each order line. However as the order number is repeated (for each product line) I cant use a vlookup. Can anyone help with an index/match formula?

[TABLE="width: 238"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Order No [/TD]
[TD]Product[/TD]
[TD]Gross Price[/TD]
[/TR]
[TR]
[TD="align: right"]12345[/TD]
[TD] abc[/TD]
[TD="align: right"]19.99[/TD]
[/TR]
[TR]
[TD="align: right"]12345[/TD]
[TD] def[/TD]
[TD="align: right"]82.99[/TD]
[/TR]
[TR]
[TD="align: right"]12346 [/TD]
[TD]abc[/TD]
[TD="align: right"]109.99[/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Try

=INDEX(Sheet2!$C$2:$C$40,MATCH(A2&B2,Sheet2!$A$2:$A$40&Sheet2!$B$2:$B$40,0))

Enter as an array, Ctrl Shift & Enter

 

[cloughie]

That's brilliant thank you.

 

[gaz_chops]

You're welcome.