Need to find information in other worksheet than current one

[Matthias1992]

Hi guys

I am using this formula =INDEX($A$1:$N$211, MATCH(Q4,A1:A211,0),MATCH(R4,A1:N1,0)).

Now how can i remake it that is looks for the info in the worksheet "prices". The formula is typed in the worksheet "invoices".

Thanks alot!

 

[123rickfear]

add prices! to the beginning of the cell references.