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?

Order No	Product	Gross Price
12345	abc	19.99
12345	def	82.99
12346	abc	109.99

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.