how to vlookup multiple values

[kisanvikas2015]

Hi everyone,

I want a function to find multiple values & then return the last matching Product.

Example: two columns of data i.e. Product & Price

Formula should check the last occurred product & then return the price of the corresponding cell.

Excel file is attached.

Regards,
Vikas

[NeedForExcel]

Here!

=LOOKUP(10^99,1/(E2=$A$2:$A$7),$B$2:$B$7)