How to get the maximum purchase price from another sheet?

Question

Google Sheets

Tell me, how to get the maximum purchase price from the "Goods Receipt" sheet using vpr and substitute it in 1 sheet?
Here is the spreadsheet
https://docs.google.com/spreadsheets/d/1X8voLVjCJO...
I am trying to use

=ВПР(МАКС(A:A)B5;'Поступления_товара'!$C$4:$I$700;5;ЛОЖЬ)

But the syntax fails...

Answer 1

Maybe,

=MAXIFS('Поступление_товара'!I2:I9;'Поступление_товара'!E2:E9;E2)

Or for articles

=MAXIFS('Поступление_товара'!I2:I9;'Поступление_товара'!C2:C9;D2)

Please note that you have lines on the source sheet with the word " magnifier " with a space at the end. Your formulas may break from this.

Answer 2

And why exactly with the help of vpr?
Use a simple max formula, e.g.
MAX('Items_in_Items'!$I$4:$I$700) will show the maximum number in the range I 4-700

Answer 3

Something like this:

=МАКС(
   filter('Поступления_товара'!$I$4:$I;'Поступления_товара'!$F$4:$F=D2)
)